title: ArcGIS Hub - JSON Stacked Bar Chart
body: <p>I am brand new to JSON so I may be missing something super simple here. I am struggling with my code that is supposed to generate a stacked bar chart with three different data sources. I want the x-axis to show the dates and the y-axis to show the count for each date (I have excluded the url and renamed the datasets):</p>
  
  <pre><code>{
    "type": "bar",
    "datasets": [
  {
    "url": "Dataset1",
    "name": "Dataset1",
    "query": {
  
      "orderByFields": "FID_count DESC",
      "groupByFieldsForStatistics": "Date",
      "outStatistics": [{
        "statisticType": "count",
        "onStatisticField": "FID",
        "outStatisticFieldName": "FID_count"
      }]
    },
    "join": "Date"
  },
  {
        "url": "Dataset2",
        "name": "Dataset2",
        "query": {
  
          "orderByFields": "FID_count DESC",
          "groupByFieldsForStatistics": "Date_",
          "outStatistics": [{
            "statisticType": "count",
            "onStatisticField": "FID",
            "outStatisticFieldName": "FID_count"
          }]
        },
        "join": "Date_"
  },
  {
            "url": "Dataset3",
            "name": "Dataset3",
            "query": {
  
              "orderByFields": "FID_count DESC",
              "groupByFieldsForStatistics": "Date",
              "outStatistics": [{
                "statisticType": "count",
                "onStatisticField": "FID",
                "outStatisticFieldName": "FID_count"
              }]
            },
            "join": "Date"
  }
  ],
    "series": [
      {
        "category": {"field": "Date", "label": "Date"},
        "value": { "field": "FID_count", "label": "Dataset1"},
        "source": "Dataset1",
        "stack": true
      },
      {
        "category": {"field": "Date_", "label": "Date"},
           "value": { "field": "FID_count", "label": "Dataset2"},
           "source": "Dataset2",
        "stack": true
      },
      {
        "category": {"field": "Date", "label": "Date"},
           "value": { "field": "FID_count", "label": "Dataset3"},
           "source": "Dataset3",
        "stack": true
      }
    ]
  }
  </code></pre>
  
  <p>No matter what adjustments I make to the code it never seems to work and I always get "There was an error in chart generation".</p>
  
  <p>I feel like this should be super easy but I am about to bang my head against the wall!</p>