<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Multiple Series Using Grouped Values in Serial Chart in ArcGIS Dashboards Questions</title>
    <link>https://community.esri.com/t5/arcgis-dashboards-questions/multiple-series-using-grouped-values-in-serial/m-p/700393#M3712</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I'm trying to assess the deference in capabilities between &lt;A href="https://esri.github.io/cedar/"&gt;cedar charts&lt;/A&gt; and serial charts in operations dashboards.&amp;nbsp; When using the grouped values option for a serial chart in an operations dashboard in AGOL/Portal:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is it possible to carry out a statistical operation on more than one field and as a result have multiple series.&amp;nbsp; Something like this which is a demo created using &lt;A href="https://services.arcgis.com/bkrWlSKcjUDFDtgw/arcgis/rest/services/DC_Crashes/FeatureServer/0/query?f=json&amp;amp;where=REPORTDATE%20%3E%20%272007-01-01%27%20AND%20REPORTDATE%20%3C%20%272018-01-01%27&amp;amp;returnGeometry=false&amp;amp;returnDistinctValues=false&amp;amp;returnIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;outFields=*&amp;amp;sqlFormat=standard&amp;amp;groupByFieldsForStatistics=EXTRACT(YEAR%20from%20REPORTDATE)&amp;amp;outStatistics=%5B%7B%22statisticType%22%3A%22sum%22%2C%22onStatisticField%22%3A%22MAJORINJURIES%22%2C%22outStatisticFieldName%22%3A%22MAJORINJURIES_SUM%22%7D%2C%7B%22statisticType%22%3A%22sum%22%2C%22onStatisticField%22%3A%22MINORINJURIES%22%2C%22outStatisticFieldName%22%3A%22MINORINJURIES_SUM%22%7D%5D&amp;amp;orderByFields=EXTRACT(YEAR%20from%20REPORTDATE)%20ASC"&gt;this query&lt;/A&gt; on cedar charts:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG __jive_id="491001" alt="" class="jive-emoji image-1 jive-image j-img-centered j-img-original" src="https://community.esri.com/legacyfs/online/491001_amCharts.png" style="display: block; margin-left: auto; margin-right: auto;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I don't seem to have the option to add more than one series unless I select 'features' in which case I don't seem to have the option to use statistics.&amp;nbsp; Are the differences between cedar charts and the serial chart widget in operations dashboards documented anywhere?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 05 May 2020 14:51:19 GMT</pubDate>
    <dc:creator>FergusFahey1</dc:creator>
    <dc:date>2020-05-05T14:51:19Z</dc:date>
    <item>
      <title>Multiple Series Using Grouped Values in Serial Chart</title>
      <link>https://community.esri.com/t5/arcgis-dashboards-questions/multiple-series-using-grouped-values-in-serial/m-p/700393#M3712</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I'm trying to assess the deference in capabilities between &lt;A href="https://esri.github.io/cedar/"&gt;cedar charts&lt;/A&gt; and serial charts in operations dashboards.&amp;nbsp; When using the grouped values option for a serial chart in an operations dashboard in AGOL/Portal:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is it possible to carry out a statistical operation on more than one field and as a result have multiple series.&amp;nbsp; Something like this which is a demo created using &lt;A href="https://services.arcgis.com/bkrWlSKcjUDFDtgw/arcgis/rest/services/DC_Crashes/FeatureServer/0/query?f=json&amp;amp;where=REPORTDATE%20%3E%20%272007-01-01%27%20AND%20REPORTDATE%20%3C%20%272018-01-01%27&amp;amp;returnGeometry=false&amp;amp;returnDistinctValues=false&amp;amp;returnIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;outFields=*&amp;amp;sqlFormat=standard&amp;amp;groupByFieldsForStatistics=EXTRACT(YEAR%20from%20REPORTDATE)&amp;amp;outStatistics=%5B%7B%22statisticType%22%3A%22sum%22%2C%22onStatisticField%22%3A%22MAJORINJURIES%22%2C%22outStatisticFieldName%22%3A%22MAJORINJURIES_SUM%22%7D%2C%7B%22statisticType%22%3A%22sum%22%2C%22onStatisticField%22%3A%22MINORINJURIES%22%2C%22outStatisticFieldName%22%3A%22MINORINJURIES_SUM%22%7D%5D&amp;amp;orderByFields=EXTRACT(YEAR%20from%20REPORTDATE)%20ASC"&gt;this query&lt;/A&gt; on cedar charts:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG __jive_id="491001" alt="" class="jive-emoji image-1 jive-image j-img-centered j-img-original" src="https://community.esri.com/legacyfs/online/491001_amCharts.png" style="display: block; margin-left: auto; margin-right: auto;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I don't seem to have the option to add more than one series unless I select 'features' in which case I don't seem to have the option to use statistics.&amp;nbsp; Are the differences between cedar charts and the serial chart widget in operations dashboards documented anywhere?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 05 May 2020 14:51:19 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-dashboards-questions/multiple-series-using-grouped-values-in-serial/m-p/700393#M3712</guid>
      <dc:creator>FergusFahey1</dc:creator>
      <dc:date>2020-05-05T14:51:19Z</dc:date>
    </item>
  </channel>
</rss>

