Historical status of cases

Petterfewf — Thu, 24 Aug 2023 12:48:37 GMT

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.

Re: Historical status of cases

Digvijay_Singh — Thu, 24 Aug 2023 12:57:39 GMT

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.

topic Re: Historical status of cases in App Development

Historical status of cases

Re: Historical status of cases