I want to put a Variant Explorer in a view.

I saw there is not a option for that, so I am trying make one. I want a chart with the most common variant but i don't know how transform the list of variants in a list with the most common variant. I was trying to filter the variants making this KPI that permit "filter" with a second KPI .

CASE WHEN COUNT(VARIANT ("BD_ACTIVITIES"."QUEUE"))> 186 THEN 1 ELSE 0 END

The secon KPI:

Case WHEN KPI("variant_most_common") = 1 THEN KPI("PROCESS_VARIANTS__BD_ACTIVITIES__QUEUE") ELSE 'OTHER' END

But it gives me this error :

The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.

Right now i don't have more ideas to can continue. I dont know if someone could help me.

Page 1 / 1

For simplicity consider using an iframe.

Put the variant explorer in an analysis which is published, then you can simply include this analysis in your view via the iframe component.

Thank you very much!

One last question by that way I won't be able to aply the filters of the variant in the view, will I?

Indeed, for that your method with the chart is better. In that case, I would suggest re-writing the KPI for the chart. Aggregations used in the KPI such as SUM(), AVG() or COUNT() will cause these errors. I suggest using case by case aggregations such as PU_SUM(), PU_AVG() instead.

Thank you, I will try that way

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN