< 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);