Open kpermenter opened 4 years ago
I put this JSON in the custom editor and saw this:
can you clarify which regions are not showing correctly?
{
"type": "area",
"datasets": [
{
"url": "https://gulfpub-gisstg.esriemcs.com/server/rest/services/EWA_Global_Assets/MapServer/3",
"name": "Asia Pacific",
"query": {
"where": "Region='Asia Pacific' AND Type='Export' AND Start_up>=1964",
"orderByFields": "Start_up",
"groupByFieldsForStatistics": "Start_up",
"outStatistics": [
{
"statisticType": "sum",
"onStatisticField": "Project_ca",
"outStatisticFieldName": "Project_ca_SUM"
}
]
},
"join": "Start_up"
},
{
"url": "https://gulfpub-gisstg.esriemcs.com/server/rest/services/EWA_Global_Assets/MapServer/3",
"name": "Middle East",
"query": {
"where": "Region='Middle East' AND Type='Export' AND Start_up>=1964",
"orderByFields": "Start_up",
"groupByFieldsForStatistics": "Start_up",
"outStatistics": [
{
"statisticType": "sum",
"onStatisticField": "Project_ca",
"outStatisticFieldName": "Project_ca_SUM"
}
]
},
"join": "Start_up"
},
{
"url": "https://gulfpub-gisstg.esriemcs.com/server/rest/services/EWA_Global_Assets/MapServer/3",
"name": "Europe",
"query": {
"where": "Region='Europe' AND Type='Export' AND Start_up>=1964",
"orderByFields": "Start_up",
"groupByFieldsForStatistics": "Start_up",
"outStatistics": [
{
"statisticType": "sum",
"onStatisticField": "Project_ca",
"outStatisticFieldName": "Project_ca_SUM"
}
]
},
"join": "Start_up"
},
{
"url": "https://gulfpub-gisstg.esriemcs.com/server/rest/services/EWA_Global_Assets/MapServer/3",
"name": "North America",
"query": {
"where": "Region='North America' AND Type='Export' AND Start_up>=1964",
"orderByFields": "Start_up",
"groupByFieldsForStatistics": "Start_up",
"outStatistics": [
{
"statisticType": "sum",
"onStatisticField": "Project_ca",
"outStatisticFieldName": "Project_ca_SUM"
}
]
},
"join": "Start_up"
},
{
"url": "https://gulfpub-gisstg.esriemcs.com/server/rest/services/EWA_Global_Assets/MapServer/3",
"name": "Africa",
"query": {
"where": "Region='Africa' AND Type='Export' AND Start_up>=1964",
"orderByFields": "Start_up",
"groupByFieldsForStatistics": "Start_up",
"outStatistics": [
{
"statisticType": "sum",
"onStatisticField": "Project_ca",
"outStatisticFieldName": "Project_ca_SUM"
}
]
},
"join": "Start_up"
},
{
"url": "https://gulfpub-gisstg.esriemcs.com/server/rest/services/EWA_Global_Assets/MapServer/3",
"name": "Latin America",
"query": {
"where": "Region='Latin America' AND Type='Export' AND Start_up>=1964",
"orderByFields": "Start_up",
"groupByFieldsForStatistics": "Start_up",
"outStatistics": [
{
"statisticType": "sum",
"onStatisticField": "Project_ca",
"outStatisticFieldName": "Project_ca_SUM"
}
]
},
"join": "Start_up"
}
],
"series": [
{
"category": {
"field": "Start_up",
"label": "Years"
},
"source": "Asia Pacific",
"value": {
"field": "Project_ca_SUM",
"label": "Asia Pacific"
}
},
{
"category": {
"field": "Start_up",
"label": "Years"
},
"source": "Middle East",
"value": {
"field": "Project_ca_SUM",
"label": "Middle East"
}
},
{
"category": {
"field": "Start_up",
"label": "Years"
},
"source": "Europe",
"value": {
"field": "Project_ca_SUM",
"label": "Europe"
}
},
{
"category": {
"field": "Start_up",
"label": "Years"
},
"source": "North America",
"value": {
"field": "Project_ca_SUM",
"label": "North America"
}
},
{
"category": {
"field": "Start_up",
"label": "Years"
},
"source": "Africa",
"value": {
"field": "Project_ca_SUM",
"label": "Africa"
}
},
{
"category": {
"field": "Start_up",
"label": "Years"
},
"source": "Latin America",
"value": {
"field": "Project_ca_SUM",
"label": "Latin America"
}
}
]
}
Looking at the graphic, I do see there is an issue where they series are "cross-linked" to one another. There may be an issue with how the Join is being done.
I have the below code and a few of the regions aren't rendering correctly. The queries are correct, so I'm guessing the definition is set up incorrectly?
Any help would be greatly appreciated!
var definition = { type: "area", datasets: [ { url: "https://gulfpub-gisstg.esriemcs.com/server/rest/services/EWA_Global_Assets/MapServer/3", name: "Asia Pacific", query: { where: "Region='Asia Pacific' AND Type='Export' AND Start_up>=1964", orderByFields: "Start_up", groupByFieldsForStatistics: "Start_up", outStatistics: [{ statisticType: "sum", onStatisticField: "Project_ca", outStatisticFieldName: "Project_ca_SUM" }] }, join: "Start_up", }, { url: "https://gulfpub-gisstg.esriemcs.com/server/rest/services/EWA_Global_Assets/MapServer/3", name: "Middle East", query: { where: "Region='Middle East' AND Type='Export' AND Start_up>=1964", orderByFields: "Start_up", groupByFieldsForStatistics: "Start_up", outStatistics: [{ statisticType: "sum", onStatisticField: "Project_ca", outStatisticFieldName: "Project_ca_SUM" }] }, join: "Start_up", }, { url: "https://gulfpub-gisstg.esriemcs.com/server/rest/services/EWA_Global_Assets/MapServer/3", name: "Europe", query: { where: "Region='Europe' AND Type='Export' AND Start_up>=1964", orderByFields: "Start_up", groupByFieldsForStatistics: "Start_up", outStatistics: [{ statisticType: "sum", onStatisticField: "Project_ca", outStatisticFieldName: "Project_ca_SUM" }] }, join: "Start_up", }, { url: "https://gulfpub-gisstg.esriemcs.com/server/rest/services/EWA_Global_Assets/MapServer/3", name: "North America", query: { where: "Region='North America' AND Type='Export' AND Start_up>=1964", orderByFields: "Start_up", groupByFieldsForStatistics: "Start_up", outStatistics: [{ statisticType: "sum", onStatisticField: "Project_ca", outStatisticFieldName: "Project_ca_SUM" }] }, join: "Start_up", }, { url: "https://gulfpub-gisstg.esriemcs.com/server/rest/services/EWA_Global_Assets/MapServer/3", name: "Africa", query: { where: "Region='Africa' AND Type='Export' AND Start_up>=1964", orderByFields: "Start_up", groupByFieldsForStatistics: "Start_up", outStatistics: [{ statisticType: "sum", onStatisticField: "Project_ca", outStatisticFieldName: "Project_ca_SUM" }] }, join: "Start_up", }, { url: "https://gulfpub-gisstg.esriemcs.com/server/rest/services/EWA_Global_Assets/MapServer/3", name: "Latin America", query: { where: "Region='Latin America' AND Type='Export' AND Start_up>=1964", orderByFields: "Start_up", groupByFieldsForStatistics: "Start_up", outStatistics: [{ statisticType: "sum", onStatisticField: "Project_ca", outStatisticFieldName: "Project_ca_SUM" }] }, join: "Start_up", }, ],
series: [ { category: { "field": "Start_up", "label": "Years" }, source: "Asia Pacific", value: { field: "Project_ca_SUM", label: "Asia Pacific", } }, { category: { "field": "Start_up", "label": "Years" }, source: "Middle East", value: { field: "Project_ca_SUM", label: "Middle East", } }, { category: { "field": "Start_up", "label": "Years" }, source: "Europe", value: { field: "Project_ca_SUM", label: "Europe", } }, { category: { "field": "Start_up", "label": "Years" }, source: "North America", value: { field: "Project_ca_SUM", label: "North America", } }, { category: { "field": "Start_up", "label": "Years" }, source: "Africa", value: { field: "Project_ca_SUM", label: "Africa", } }, { category: { "field": "Start_up", "label": "Years" }, source: "Latin America", value: { field: "Project_ca_SUM", label: "Latin America", } }, ] } var chart = new cedar.Chart("chartLine2", definition); chart.show();