I have indicators in my dashboards that include a count of the # of requests received on different topics. I have 4 different selectors that filter the indicators based on different variables (e.g. Open vs. Closed). What I would like to do is have the total # of requests in the indicator for each topic and have this value stay static - i.e., it stays the same regardless of how the filters are selected. So, in the image I've included, the dashboard is filtered to show open requests - both values in the indicator are being filtered but I really want the bottom one to include the total # of requests, not just the open ones.
I was wondering if this might be possible using Arcade? Like maybe setting a fixed reference value and then creating a variable to populate that fixed value? Or is there a simpler way to do this? I can't seem to figure out if this is possible. Any help is appreciated.
Samara
Solved! Go to Solution.
You can try setting the Reference in the Data pane to Count the records (OBJECTID).
Then call the {reference} value in the Description, not the bottom text.
You can try setting the Reference in the Data pane to Count the records (OBJECTID).
Then call the {reference} value in the Description, not the bottom text.
Yes, that worked! And then in the selector options, I'm able to choose if I want the main value and/or the referenced value filtered. Thank you so much!!
Samara