Skip to main content
Hi All,

 

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.Case - number of cases in each status over the last 30 days
9 answers
  1. Aug 19, 2019, 2:46 PM
    You will have to use standard report type Case Rupal

     

    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

     

    Creating grouping like below

     

    User-added image

     

     

    Add the filter criteria on the date 

     

    User-added image

     

     

     

    Sort the date field by Calendar Week

     

    User-added image

     

     

     

    and your end result 

     

    User-added image

     

     
0/9000