Latest Contributions by NiuZheng

Hi   is there any way to format the decimal places of number of outStatisticField in following query?      Order By Fields: SUM_MEAN_MEAN_Delay DESC   Group By Fields (For Statistics): FIRST_Street   Output Statistics: [ { "statisticType": "sum", "onStatisticField": "MAX_MAX_Delay", "outStatisticFieldName": "SUM_MEAN_MEAN_Delay" } ]   result  SUM_MEAN_MEAN_Delay: 1527.09699999989 FIRST_Street: Hwy 7 SUM_MEAN_MEAN_Delay: 768.143999999995 FIRST_Street: Hwy 401 E SUM_MEAN_MEAN_Delay: 579.484999999999 FIRST_Street: Hwy 401 Collector W SUM_MEAN_MEAN_Delay: 562.704999999997 FIRST_Street: Hwy 401 Express E if I want to format the return value as #,###.00 how to do it? so far, there is no explanation found from REST API help   Thanks alot   https://services.arcgis.com/6iGx1Dq91oKtcE7x/ArcGIS/rest/services/congestion_summary/FeatureServer/1/query?where=&objectIds=&time=&resultType=standard&outFields=*&returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnDistinctValues=false&cacheHint=false&orderByFields=SUM_MEAN_MEAN_Delay+DESC&groupByFieldsForStatistics=FIRST_Street&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&having=&resultOffset=&resultRecordCount=10&sqlFormat=none&f=html&token=         ... View more

Can any one help to answer two questions? 1) how to configure the number format for value in tooltip? 2) is there a way to convert value on the fly without change its self in data? I am using JSON chart in Hub.I tested code using   https://esri.github.io/cedar/ the value of outStatisticFieldName "MAX_MAX_De_sum" from the query, I want to make sure its display format to be "#,###.00" in tooltip. do convert and show new calculated value of "MAX_MAX_De_sum/60". I tried the alternative way as suggested by someone here by applying "Cast(MAX_MAX_De as decimal(10,2)) to the "onStatisticField". it works if when using "orderByFields": "FIRST_Str", but always return unknown error (also shows "MAX_MAX_De_sum " is not valid parameter) when using "orderByFields": "MAX_MAX_De_sum DESC" really appreciated for your help { "type": "bar-horizontal", "numberFormatter":[{ "numberFormat":{"decimalSeparator":".", "thousandsSeparator":",", "precision":-1} }], "datasets": [ { "name": "dataset1", "query": { "where": "FIRST_Stre <>' ' and FIRST_Stre <> 'Hwy 7'", "orderByFields": "MAX_MAX_De_sum DESC", "groupByFieldsForStatistics": "FIRST_Stre", "having": "SUM(MAX_MAX_De)>24", "outStatistics": [ { "statisticType": "sum", "onStatisticField": "MAX_MAX_De", "outStatisticFieldName": "MAX_MAX_De_sum" } ] }, "url": "https://services.arcgis.com/6iGx1Dq91oKtcE7x/arcgis/rest/services/UUID_Delay_Summary_Hourly_pub_view1/FeatureServer/0" } ], "series": [ { "source": "dataset1", "category": { "field": "FIRST_Stre", "label": "Highway" }, "value": { "field": "cast(MAX_MAX_De_sum as decimal(10,2))", "label": "Delay (in sec)" } } ], "style": { "colors": [ "#026873" ] }, "overrides": { "graphs": [{ "valueField" : "MAX_MAX_De_sum", "balloonText": "[[MAX_MAX_De_sum]]", "numberFormatter":{"decimalSeparator":".", "thousandsSeparator":",", "precision":2,"numberFormat": "#,###.00"} }], "valueAxes": [{ "title": "Elevation (feets)", "numberFormatter": { "numberFormat": "#,###.00" } }], "xAxes":[{ "numberFormatter": { "numberFormat": "#,###.00" } }] } }   ... View more