Skip to main content
Hi, I am trying to show the number of cases devided by variants of process using following dimension and KPIs.
Dimension
DISTINCT (VARIANT("_CEL_MM_ACTIVITIES"."ACTIVITY_JA"))
ACTIVITY_JA contains the name of activities
KPIs
COUNT_TABLE("_CEL_MM_ACTIVITIES_CASES")
Only the Bar Chart is refused to show the result showing following error. OLAP and other types of graphics elements show successfully what I want.

I believe the code is pretty simple, I cannot understand why the code does not work only in the Bar Chart.
I have tried following things already, fyi;
  • writing without DISTINCT
  • writing with SHORTEND
  • counting other things e.g. ACTIVITIES

Please let me know should you require additional information concerning this issue.
Best

Hi Tomoki,

 

if I understand correctly, you want to see how many cases are happening for one process variation? Since you applied the Case Count already as a KPI you do not need the DISTINCT since this will be grouped automatically. Can you please try VARIANT("_CEL_MM_ACTIVITIES"."ACTIVITY_JA") as the dimension input and see if this works.

 

This is the output I get using:

Dimension: VARIANT("_CEL_MM_ACTIVITIES"."ACTIVITY_JA")

KPI: COUNT_TABLE(CASE_TABLE)

 

image.pngBest

Kevin

 


Reply