Hi,
I'm trying to display a chart in the hub, using the JSON option on the chart card. I'm really close to achieving what I want, I just can't figure out the last bit. I'm trying to plot election candidate results in a bar chart. Each candidate is represented as a column and their votes are field values by precinct. I simply want to sum their total votes and plot them against each other. I think it's my data table making things tricky. If the table was pivot'd I think it'd be easier to do this.
Right now I'm having 2 problems -
1) In my series-category, I get "undefined" for each candidate. The field property is looking to get a value from the field. But the field name itself is the candidate name.
2) My candidates get stacked in the bar chart. I think this is how I'm using the series value, but I can't come up with another way to display more than 1 candidate than adding entries to the list like I've done.
<SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"type"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"bar-horizontal"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"datasets"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN>
<SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"url"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token"><SPAN>"</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fservices.arcgis.com%2FG6F8XLCl5KtAlZ2G%2Farcgis%2Frest%2Fservices%2FOttawa_2018_Election_Results%2FFeatureServer%2F16" target="_blank">https://services.arcgis.com/G6F8XLCl5KtAlZ2G/arcgis/rest/services/Ottawa_2018_Election_Results/FeatureServer/16</A><SPAN>"</SPAN></SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"name"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Watson"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"query"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"orderByFields"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Number_of_SUM DESC"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"outStatistics"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN>
<SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"statisticType"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"sum"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"onStatisticField"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Jim_Watson"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"outStatisticFieldName"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Number_of_SUM"</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">]</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"url"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token"><SPAN>"</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fservices.arcgis.com%2FG6F8XLCl5KtAlZ2G%2Farcgis%2Frest%2Fservices%2FOttawa_2018_Election_Results%2FFeatureServer%2F16" target="_blank">https://services.arcgis.com/G6F8XLCl5KtAlZ2G/arcgis/rest/services/Ottawa_2018_Election_Results/FeatureServer/16</A><SPAN>"</SPAN></SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"name"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Doucet"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"query"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"orderByFields"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Number_of_SUM DESC"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"outStatistics"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN>
<SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"statisticType"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"sum"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"onStatisticField"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Clive_Doucet"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"outStatisticFieldName"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Number_of_SUM"</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">]</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"series"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN>
<SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"category"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"field"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Jim_Watson"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"label"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Candidates"</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"value"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"field"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Number_of_SUM"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"label"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Watson"</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"source"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Watson"</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"category"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"field"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Clive_Doucet"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"label"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Candidates"</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"value"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"field"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Number_of_SUM"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"label"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Doucet"</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"source"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Doucet"</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"overrides"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"categoryAxis"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"labelRotation"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">45</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>
