topic Re: Dashboard Indicator in ArcGIS Dashboards Questions

Dashboard Indicator

johnnytran01 — Mon, 11 Apr 2022 17:00:48 GMT

Could someone help me on this? I have two columns PartyType1 and PartyType2. I am trying to create an indicator of the type PartyType1 and 2. For PartyType1, I have 18 Bicycle, for PartyType2, I have 11. Total should be 29 but for some reason the indicator does not count when PartyType1 and PartyType2 are equal to Bicycle.

Re: Dashboard Indicator

jcarlson — Mon, 11 Apr 2022 17:17:45 GMT

Your indicator is going to be counting per row, so if one of your rows has "Bicycle" in both columns, it still only gets counted once.

If you want the total number of occurrences across the two fields, you might consider using a Data Expression. Here's an example expression that calculates a value using two fields: https://github.com/Esri/arcade-expressions/blob/master/dashboard_data/CalculationAcrossFields.md

Re: Dashboard Indicator

johnnytran01 — Mon, 11 Apr 2022 22:27:52 GMT

Hi Josh,

Thank you for recommendation. So I tried creating an expression, but I am getting this error Execution Error: Cannot read properties of null (reading 'replace').

Re: Dashboard Indicator

jcarlson — Tue, 12 Apr 2022 13:47:46 GMT

Hmmm.... I've never seen that error message before. Perhaps an Esri person would know more what that means.