Dashboard element that displays number of days?

[RHammers]

I have a dashboard that is used to track open cases and would like to configure a list element that will display how long each case has been open, among other things.

The closest solution I have seen is a calculation in the survey. The issue there is that the dates will not update as time passes, so surveys would need to be re-submitted daily to update the calculation. Is there a better way to achieve this?

Thank you!

[RickeyFight · Accepted solution]

@RHammers 
This is how I did it
https://www.esri.com/arcgis-blog/products/ops-dashboard/real-time/displaying-time-spans-with-arcade-...

[RHammers]

Perfect, thank you!

Next question: Is it possible to have the calculated text appear only when a specific question is answered with a specific answer? In my case I do not want the calculated text to appear when the case is closed.

[RickeyFight]

I believe you could just add an if statement.

// Check if specific question is answered with a specific answer

if ($feature['specific_question'] == 'specific_answer') {

// Display calculated text return 'Your calculated text goes here';

} else {

// If the condition is not met, return an empty string

return '';

}

https://community.esri.com/t5/arcgis-online-documents/conditional-field-display-with-arcade-in-pop-u...

https://github.com/Esri/arcade-expressions/tree/master/dashboard_data