Hi all,
I would like to calculate the automation quota of the activities of a process using a dashboard. To do this, I have created a query that searches the BPMN processes for the activities they contain and outputs the symbol type (user task, service task, ...). You can see the dashboard in the screenshot. With 1 the group can be selected and with 2 the respective process. After process selection the values change to 3,4,5 as the number of tasks varies. However, the value of the quota remains the same and does not change with the process selection.
The formula is: (Service Task / Task Total) *100 and I have created this using RAQL Inline.
Stream 6 shows the number of service tasks. stream 4 shows the total number. what do I have to do so that the quota is dependent on the process selection?
thx
Stephan
Monika Leitner on
Hi Stephan,
From the screenshots it is a little bit difficult.
But you have to make sure that you hand over the filter criterias via user parameters before the aggregation step.
For that you would need
Filter rows data operator before the aggregation and assign the column scenario to user input variable
And on the filter widget (column scenario) you have to assign also the user variable
And then the ratio KPI will be filtered by scenario
Best
Monika