I am looking for ways to accomplish the example listed below when adding an indicator in the dashboard. I believe the advanced formatting function can help me do that, but I can't get it to work. Would like the community to share suggestions!
I have added an indicator element into ArcGIS dashboard application. The indicator will display a numeric variable/value ‘cases’ and references the same numeric variable from to previous week ‘cases’. I want to suppress the data if the case count <10 so anything from 1-9 would say ‘suppressed’, case count 0 or 10 and above would be displayed.
The example data would be:
Date | Week | Cases |
10/1/23 | 1 | 5 |
10/8/23 | 2 | 10 |
10/15/23 | 3 | 8 |
10/22/23 | 4 | 4 |
The indicator box based on the value at or above/below reference value would look like this:
Example 1, Reporting on Week 2:
Cases
10
Suppressed (previous week)
Example 2, Reporting on Week 3:
Cases
Suppressed
10 (previous week)
Example 3, Reporting on Week 4:
Cases
Suppressed
Suppressed (previous week)
