Skip to main content

I'd like to create table.

 

Added a column (A-B FLAG) PQL to the OLAP table on the dashboard that determines A and B. (Not on the data table.)

 

I want to create a pie chart on the Celonis dashboard that counts A and B and the number of each.

 

In that case, what formula should I add for KPI and Dimension, respectively?

Not sure if I understand your request, but wouldn't that be the PQL query of your table that states A-B in the dimension, and the number of cases in the KPI (something like COUNT_TABLE('CASE_TABLE') )?


Reply