< Back Home
var config1 = {
      "type": "bar",
      "url": "https://servicesqa.arcgis.com/97KLIFOSt5CxbiRI/arcgis/rest/services/Crashes_in_the_District_of_Columbia/FeatureServer/0",
    "query": {
        "orderByFields": "EXTRACT(MONTH from REPORTDATE)",
        "groupByFieldsForStatistics": "EXTRACT(MONTH from REPORTDATE)",
        "outStatistics": "[{'statisticType':'sum','onStatisticField': 'MAJORINJURIES','outStatisticFieldName': 'MAJORINJURIES'},{'statisticType':'sum','onStatisticField': 'MINORINJURIES','outStatisticFieldName': 'MINORINJURIES'}]"
    },
    "mappings":{
      "category": {"field": "EXPR_1", "label": "Month"},
      "series": [
        { "field": "MINORINJURIES", "label": "Minor Injuries"},
        { "field": "MAJORINJURIES", "label": "Major Injuries"}
      ]
  }
}

showChart("chartdiv1", config1);

var config2 = {
      "type": "bar",
      "url": "https://servicesqa.arcgis.com/97KLIFOSt5CxbiRI/arcgis/rest/services/Crashes_in_the_District_of_Columbia/FeatureServer/0",
    "query": {
        "orderByFields": "EXTRACT(MONTH from REPORTDATE)",
        "groupByFieldsForStatistics": "EXTRACT(MONTH from REPORTDATE)",
        "outStatistics": "[{'statisticType':'sum','onStatisticField': 'PEDESTRIANSINVOLVED','outStatisticFieldName': 'PEDESTRIANSINVOLVED'},{'statisticType':'sum','onStatisticField': 'CYCLISTSINVOLVED','outStatisticFieldName': 'CYCLISTSINVOLVED'}]"
    },
    "mappings":{
      "category": {"field": "EXPR_1", "label": "Month"},
      "group": true,
      "series": [
        { "field": "PEDESTRIANSINVOLVED", "label": "Pedestrians"},
        { "field": "CYCLISTSINVOLVED", "label": "Cyclists"}
      ]
  }
}
showChart("chartdiv2", config2);