
I need to create a report to be able to show funnel of case statuses week by week for the last 30 days. I tried using Cases Lifecycle report but it gives inaccurate results.
Attaching a view of what output should look like.
9 answers
You will have to use standard report type Case Rupal
Creating grouping like below
Add the filter criteria on the date
Sort the date field by Calendar Week
and your end result