Question

Is there a way to pass variables as static filter parameter values?

Chart setup page with calculation of average duration in minutes

Take for example this setup,  Status change history is similar to Case Lifecycle in Cases, I want to find a way to add status ranges as 2 - Quick filters configured to Lookup- Status, with intended behavior as 1 Filter will initial status and 2nd Filter will be the final status and I will calculate the duration (average) for cases.

So the query will be -  Find average duration of cases moving from one status to another. 

  Version 8.3.0.3031
 

Like 0

Like

1 comments

If not can anyone help me with a correct approach for this, thanks for the help :) 

Show all comments