Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Petterfewf
Contributor
Contributor

Historical status of cases

I work at a place where we process incoming cases. All cases have a created date and a date for when the case is resolved. Is it possible to create a timeline that shows all the cases that have not been resolved at a selected time.

Labels (1)
1 Reply
Digvijay_Singh

You should share your relevant fields like date, case status etc or how did you try to solve this. May be share some sample data or sample app -

Something like this may be based on lots of assumption about your data model - 

(1) Make selections in the time period filter

(2) KPI object with expression like - Count({<CaseStatus={'Unresolved'}>}CaseID)

OR in the line chart, add MonthYear field as dimension and use above expression as measure, it should show trend of unresolved cases in each month.