function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Hermann Oure 6Hermann Oure 6 

case status backlog report

Hello,

I would like to create a backlog report / dashboard that compare the number of cases that are (In progress / escalated) against the number of cases closed on a daily basis.
My cases status are as follow:
New
In progress
Escalated
Closed

I have created a dashboard showing me the correct record count but I am unable to sort it by date.
User-added imageAnd when trying with a case history report. I am unable to have the correct record count for In progress / Escalated / Closed cases.

Ideally, I am trying to have a backlog report showing my cases 
In progress
Escalated
Closed
Something similar to the report below but instead of created / closed, I need to be able to show: In progress - Escalated -  Closed
User-added imageAny pointers on how I could create this type of report / dashboard?

Thank you,
Hermann