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 1

Like

3 comments

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

Hello!
In Creatio, it’s not possible to directly pass variables into filters. 

However, as a workaround, the user can create a custom view, similar to the one used for Opportunities — “View for analysis of sales by stages”.

Additionally, it’s possible to:

  • Install the Calculated Metrics for Creatio
    add-on from the Marketplace to calculate average values, or
  • Develop a custom business process to compute such data automatically.
     

Hello Valeriia,

Thanks for the reply. I will experiment with the approaches will let you know what worked best for me. 

 

 

Thanks

Rishav

Show all comments