< Back Home

Multiple Series

whereby we illustrate a method for the graphing of multiple series of data utilizing queries of a Geoservice. 
  
    var config1 = {
      "type": "bar",
      "datasets": [
        {
          "url": "https://services.arcgis.com/uDTUpUPbk8X8mXwl/arcgis/rest/services/Public_Schools_in_Onondaga_County/FeatureServer/0",
          "query": {
            "where": "City='Jordan'",
            "orderByFields": "Number_of_SUM DESC",
            "groupByFieldsForStatistics": "Type",
            "outStatistics": [{
              "statisticType": "sum",
              "onStatisticField": "Number_of",
              "outStatisticFieldName": "Number_of_SUM"
            }]
          },
          "mappings":{
            "category": {"field": "Type", "label": "Type"},
            "group": true,
            "series": [
              { "field": "Number_of_SUM", "label": "Jordan Students"}
            ]
          }
        },
        {
          "url": "https://services.arcgis.com/uDTUpUPbk8X8mXwl/arcgis/rest/services/Public_Schools_in_Onondaga_County/FeatureServer/0",
              "query": {
                "where": "City='Dewitt'",
                "orderByFields": "Number_of_SUM DESC",
                "groupByFieldsForStatistics": "Type",
                "outStatistics": [{
                  "statisticType": "sum",
                  "onStatisticField": "Number_of",
                  "outStatisticFieldName": "Number_of_SUM"
                }]
              },
          "mappings":{
          "category": {"field": "Type", "label": "Type"},
          "group": true,
          "series": [
            { "field": "Number_of_SUM", "label": "Dewitt Students"}
          ]
          }
        },
        {
          "url": "https://services.arcgis.com/uDTUpUPbk8X8mXwl/arcgis/rest/services/Public_Schools_in_Onondaga_County/FeatureServer/0",
          "query": {
            "where": "City='Fayetteville'",
            "orderByFields": "Number_of_SUM DESC",
            "groupByFieldsForStatistics": "Type",
            "outStatistics": [{
              "statisticType": "sum",
              "onStatisticField": "Number_of",
              "outStatisticFieldName": "Number_of_SUM"
            }]
          },
          "mappings":{
            "category": {"field": "Type", "label": "Type"},
            "group": true,
            "series": [
              { "field": "Number_of_SUM", "label": "Fayetteville Students"}
            ]
          }
        }
      ]
  }

showChart("chartdiv1", config1);