Is there a way to pass variables as static filter parameter values?
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
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