idea Custom Calculation in Operations Dashboard in ArcGIS Dashboards Ideas https://community.esri.com/t5/arcgis-dashboards-ideas/custom-calculation-in-operations-dashboard/idi-p/932088 <HTML><HEAD></HEAD><BODY><P>I've been trying to perform a custom calculation on a single field and display the result as a gauge or indicator that can be filtered - the field I'm trying to calculate has values between 1 &amp; 10 and the calculation I'm trying to perform is:</P><P></P><P>Percent of values between&nbsp;9-10 (minus) percent of values between 1-6</P><P></P><P>I'd like to be able to use a formula along the lines of ( (countif(field &gt;= 9) / countif(field &gt;0)) - (<SPAN>countif(field &lt;= 6) / countif(field &gt;0))&nbsp;)*100 and just display the result as&nbsp;the value for a gauge or indicator</SPAN></P><P></P><P><SPAN>Ian</SPAN></P></BODY></HTML> Wed, 19 Dec 2018 05:53:04 GMT Anonymous User 2018-12-19T05:53:04Z Custom Calculation in Operations Dashboard https://community.esri.com/t5/arcgis-dashboards-ideas/custom-calculation-in-operations-dashboard/idi-p/932088 <HTML><HEAD></HEAD><BODY><P>I've been trying to perform a custom calculation on a single field and display the result as a gauge or indicator that can be filtered - the field I'm trying to calculate has values between 1 &amp; 10 and the calculation I'm trying to perform is:</P><P></P><P>Percent of values between&nbsp;9-10 (minus) percent of values between 1-6</P><P></P><P>I'd like to be able to use a formula along the lines of ( (countif(field &gt;= 9) / countif(field &gt;0)) - (<SPAN>countif(field &lt;= 6) / countif(field &gt;0))&nbsp;)*100 and just display the result as&nbsp;the value for a gauge or indicator</SPAN></P><P></P><P><SPAN>Ian</SPAN></P></BODY></HTML> Wed, 19 Dec 2018 05:53:04 GMT https://community.esri.com/t5/arcgis-dashboards-ideas/custom-calculation-in-operations-dashboard/idi-p/932088 Anonymous User 2018-12-19T05:53:04Z Re: Custom Calculation in Operations Dashboard - Status changed to: Already Offered https://community.esri.com/t5/arcgis-dashboards-ideas/custom-calculation-in-operations-dashboard/idc-p/1224014#M1865 <P>Something like this could be done with a <A href="https://doc.arcgis.com/en/dashboards/latest/reference/authoring-data-expressions.htm" target="_blank" rel="noopener">data expression</A>.&nbsp;</P> Thu, 20 Oct 2022 19:46:20 GMT https://community.esri.com/t5/arcgis-dashboards-ideas/custom-calculation-in-operations-dashboard/idc-p/1224014#M1865 patrickb 2022-10-20T19:46:20Z