<?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 number format issue outStatisticField in feature layer query in ArcGIS Online Questions</title>
    <link>https://community.esri.com/t5/arcgis-online-questions/number-format-issue-outstatisticfield-in-feature/m-p/1005647#M37560</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;is there any way to format the decimal places of number of&amp;nbsp;outStatisticField in following query?&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;TABLE width="635px"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="117px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="118px" height="25px"&gt;Order By Fields:&lt;/TD&gt;&lt;TD width="399px"&gt;SUM_MEAN_MEAN_Delay DESC&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="117px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="118px" height="25px"&gt;Group By Fields (For Statistics):&lt;/TD&gt;&lt;TD width="399px"&gt;FIRST_Street&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="117px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="118px" height="157px"&gt;Output Statistics:&lt;/TD&gt;&lt;TD width="399px" height="157px"&gt;[&lt;BR /&gt;{&lt;BR /&gt;"statisticType": "sum",&lt;BR /&gt;"onStatisticField": "MAX_MAX_Delay",&lt;BR /&gt;"outStatisticFieldName": "SUM_MEAN_MEAN_Delay"&lt;BR /&gt;}&lt;BR /&gt;]&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;result&amp;nbsp;&lt;/P&gt;&lt;P&gt;SUM_MEAN_MEAN_Delay: 1527.09699999989&lt;BR /&gt;FIRST_Street: Hwy 7&lt;/P&gt;&lt;P&gt;SUM_MEAN_MEAN_Delay: 768.143999999995&lt;BR /&gt;FIRST_Street: Hwy 401 E&lt;/P&gt;&lt;P&gt;SUM_MEAN_MEAN_Delay: 579.484999999999&lt;BR /&gt;FIRST_Street: Hwy 401 Collector W&lt;/P&gt;&lt;P&gt;SUM_MEAN_MEAN_Delay: 562.704999999997&lt;BR /&gt;FIRST_Street: Hwy 401 Express E&lt;/P&gt;&lt;P&gt;if I want to format the return value as #,###.00&lt;/P&gt;&lt;P&gt;how to do it? so far, there is no explanation found from REST API help&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks alot&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;A href="https://services.arcgis.com/6iGx1Dq91oKtcE7x/ArcGIS/rest/services/congestion_summary/FeatureServer/1/query?where=&amp;amp;objectIds=&amp;amp;time=&amp;amp;resultType=standard&amp;amp;outFields=*&amp;amp;returnIdsOnly=false&amp;amp;returnUniqueIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;returnDistinctValues=false&amp;amp;cacheHint=false&amp;amp;orderByFields=SUM_MEAN_MEAN_Delay+DESC&amp;amp;groupByFieldsForStatistics=FIRST_Street&amp;amp;outStatistics=%5B%0D%0A++++++++++%7B%0D%0A++++++++++++%22statisticType%22%3A+%22sum%22%2C%0D%0A++++++++++++%22onStatisticField%22%3A+%22MAX_MAX_Delay%22%2C%0D%0A++++++++++++%22outStatisticFieldName%22%3A+%22SUM_MEAN_MEAN_Delay%22%0D%0A++++++++++%7D%0D%0A++++++++%5D&amp;amp;having=&amp;amp;resultOffset=&amp;amp;resultRecordCount=10&amp;amp;sqlFormat=none&amp;amp;f=html&amp;amp;token=" target="_blank" rel="noopener"&gt;https://services.arcgis.com/6iGx1Dq91oKtcE7x/ArcGIS/rest/services/congestion_summary/FeatureServer/1/query?where=&amp;amp;objectIds=&amp;amp;time=&amp;amp;resultType=standard&amp;amp;outFields=*&amp;amp;returnIdsOnly=false&amp;amp;returnUniqueIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;returnDistinctValues=false&amp;amp;cacheHint=false&amp;amp;orderByFields=SUM_MEAN_MEAN_Delay+DESC&amp;amp;groupByFieldsForStatistics=FIRST_Street&amp;amp;outStatistics=%5B%0D%0A++++++++++%7B%0D%0A++++++++++++%22statisticType%22%3A+%22sum%22%2C%0D%0A++++++++++++%22onStatisticField%22%3A+%22MAX_MAX_Delay%22%2C%0D%0A++++++++++++%22outStatisticFieldName%22%3A+%22SUM_MEAN_MEAN_Delay%22%0D%0A++++++++++%7D%0D%0A++++++++%5D&amp;amp;having=&amp;amp;resultOffset=&amp;amp;resultRecordCount=10&amp;amp;sqlFormat=none&amp;amp;f=html&amp;amp;token=&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Mon, 30 Nov 2020 20:37:46 GMT</pubDate>
    <dc:creator>NiuZheng</dc:creator>
    <dc:date>2020-11-30T20:37:46Z</dc:date>
    <item>
      <title>number format issue outStatisticField in feature layer query</title>
      <link>https://community.esri.com/t5/arcgis-online-questions/number-format-issue-outstatisticfield-in-feature/m-p/1005647#M37560</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;is there any way to format the decimal places of number of&amp;nbsp;outStatisticField in following query?&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;TABLE width="635px"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="117px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="118px" height="25px"&gt;Order By Fields:&lt;/TD&gt;&lt;TD width="399px"&gt;SUM_MEAN_MEAN_Delay DESC&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="117px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="118px" height="25px"&gt;Group By Fields (For Statistics):&lt;/TD&gt;&lt;TD width="399px"&gt;FIRST_Street&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="117px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="118px" height="157px"&gt;Output Statistics:&lt;/TD&gt;&lt;TD width="399px" height="157px"&gt;[&lt;BR /&gt;{&lt;BR /&gt;"statisticType": "sum",&lt;BR /&gt;"onStatisticField": "MAX_MAX_Delay",&lt;BR /&gt;"outStatisticFieldName": "SUM_MEAN_MEAN_Delay"&lt;BR /&gt;}&lt;BR /&gt;]&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;result&amp;nbsp;&lt;/P&gt;&lt;P&gt;SUM_MEAN_MEAN_Delay: 1527.09699999989&lt;BR /&gt;FIRST_Street: Hwy 7&lt;/P&gt;&lt;P&gt;SUM_MEAN_MEAN_Delay: 768.143999999995&lt;BR /&gt;FIRST_Street: Hwy 401 E&lt;/P&gt;&lt;P&gt;SUM_MEAN_MEAN_Delay: 579.484999999999&lt;BR /&gt;FIRST_Street: Hwy 401 Collector W&lt;/P&gt;&lt;P&gt;SUM_MEAN_MEAN_Delay: 562.704999999997&lt;BR /&gt;FIRST_Street: Hwy 401 Express E&lt;/P&gt;&lt;P&gt;if I want to format the return value as #,###.00&lt;/P&gt;&lt;P&gt;how to do it? so far, there is no explanation found from REST API help&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks alot&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;A href="https://services.arcgis.com/6iGx1Dq91oKtcE7x/ArcGIS/rest/services/congestion_summary/FeatureServer/1/query?where=&amp;amp;objectIds=&amp;amp;time=&amp;amp;resultType=standard&amp;amp;outFields=*&amp;amp;returnIdsOnly=false&amp;amp;returnUniqueIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;returnDistinctValues=false&amp;amp;cacheHint=false&amp;amp;orderByFields=SUM_MEAN_MEAN_Delay+DESC&amp;amp;groupByFieldsForStatistics=FIRST_Street&amp;amp;outStatistics=%5B%0D%0A++++++++++%7B%0D%0A++++++++++++%22statisticType%22%3A+%22sum%22%2C%0D%0A++++++++++++%22onStatisticField%22%3A+%22MAX_MAX_Delay%22%2C%0D%0A++++++++++++%22outStatisticFieldName%22%3A+%22SUM_MEAN_MEAN_Delay%22%0D%0A++++++++++%7D%0D%0A++++++++%5D&amp;amp;having=&amp;amp;resultOffset=&amp;amp;resultRecordCount=10&amp;amp;sqlFormat=none&amp;amp;f=html&amp;amp;token=" target="_blank" rel="noopener"&gt;https://services.arcgis.com/6iGx1Dq91oKtcE7x/ArcGIS/rest/services/congestion_summary/FeatureServer/1/query?where=&amp;amp;objectIds=&amp;amp;time=&amp;amp;resultType=standard&amp;amp;outFields=*&amp;amp;returnIdsOnly=false&amp;amp;returnUniqueIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;returnDistinctValues=false&amp;amp;cacheHint=false&amp;amp;orderByFields=SUM_MEAN_MEAN_Delay+DESC&amp;amp;groupByFieldsForStatistics=FIRST_Street&amp;amp;outStatistics=%5B%0D%0A++++++++++%7B%0D%0A++++++++++++%22statisticType%22%3A+%22sum%22%2C%0D%0A++++++++++++%22onStatisticField%22%3A+%22MAX_MAX_Delay%22%2C%0D%0A++++++++++++%22outStatisticFieldName%22%3A+%22SUM_MEAN_MEAN_Delay%22%0D%0A++++++++++%7D%0D%0A++++++++%5D&amp;amp;having=&amp;amp;resultOffset=&amp;amp;resultRecordCount=10&amp;amp;sqlFormat=none&amp;amp;f=html&amp;amp;token=&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 30 Nov 2020 20:37:46 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-online-questions/number-format-issue-outstatisticfield-in-feature/m-p/1005647#M37560</guid>
      <dc:creator>NiuZheng</dc:creator>
      <dc:date>2020-11-30T20:37:46Z</dc:date>
    </item>
    <item>
      <title>Re: number format issue outStatisticField in feature layer query</title>
      <link>https://community.esri.com/t5/arcgis-online-questions/number-format-issue-outstatisticfield-in-feature/m-p/1005932#M37574</link>
      <description>&lt;P&gt;this issue was solved see here&amp;nbsp;&lt;A href="https://github.com/Esri/cedar/issues/477" target="_blank"&gt;https://github.com/Esri/cedar/issues/477&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 01 Dec 2020 18:25:18 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-online-questions/number-format-issue-outstatisticfield-in-feature/m-p/1005932#M37574</guid>
      <dc:creator>NiuZheng</dc:creator>
      <dc:date>2020-12-01T18:25:18Z</dc:date>
    </item>
  </channel>
</rss>

