Skip to main content
Question

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

  • May 15, 2023
  • 1 reply
  • 5 views
A
Level 0

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

    1 reply

    N
    Celonaut
    Forum|alt.badge.img+4

    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.

    Community Code of ConductAccessibility statement