Hallo, ich habe eine OLAP Tabelle erstellt unter anderem mit einer Spalte wie unter Details.Jetzt möchte ich ein Histogramm, mit x-Achse Datum und y-Achse Anz. der Fälle mit "iO", "niO" und keine Info. Allerdings bekomme ich die Count-Funktion n

Question

CASE

WHEN

BIND_FILTERS (

"_Q_CASES" ,

"vw_IPM"."AFO_Nummer" LIKE 'aa-%' AND

"vw_IPM"."Status_Verschraubung" = 'niO'

)

THEN

'niO'

WHEN

BIND_FILTERS (

"_MAN_QUALITÄT_CASES" ,

"vw_IPM"."AFO_Nummer" LIKE 'aa-%' AND

"vw_IPM"."Status_Verschraubung" = 'iO'

)

THEN

'iO'

WHEN

BIND_FILTERS (

"_MAN_QUALITÄT_CASES" ,

"vw_IPM"."AFO_Nummer" LIKE 'bb_%' AND

"vw_IPM"."Status_Verschraubung" = 'niO'

)

THEN

'niO'

WHEN

BIND_FILTERS (

"_MAN_QUALITÄT_CASES" ,

"vw_IPM"."AFO_Nummer" LIKE 'bb_%' AND

"vw_IPM"."Status_Verschraubung" = 'iO'

)

THEN

'iO'

ELSE

'keine Info'

END

nadeen.gboor12 · Answer

Hi Athina, Thank you for your question.I would suggest to use a bar graph instead of a histogram. You can then create three KPIs based on the code you shared, one KPI counting "iO", one KPI counting "niO", and one KPI counting "keine Info".Hope this helps with creating a bar chart instead of a histogram. If not, then please further elaborate on the issue with using the Count function.

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