6 Replies Latest reply: Mar 28, 2017 5:08 AM by omar bensalem RSS

    Concatenante dim and measure in a chart (pie chart)

    omar bensalem

      Hi everyone ( stalwar1),

       

      I have a pie chart,

      as a dimension: Sens

      as a measure: Count({<$(vSetPeriodPres),Code_Ligne={'MAL'},Groupe_Complet_Vide={c,C,G}>}Dossier)

       

       

      here is the current output  :


      Capture.PNG

       

      Now, what I'm trying to do is having next to N->S and S->N the % of the total.

      I'll then need to alter my dimension and add to it a measure :

      Sens&' / '&

      ($(=Count({<$(vSetPeriodPres),Code_Ligne={'MAL'},Groupe_Complet_Vide={c,C,G}>}Dossier))

      /

      $(=Count({<$(vSetPeriodPres),Code_Ligne={'MAL'},Groupe_Complet_Vide={c,C,G}>}TOTAL Dossier)))


      But this is always showing 1:


      Capture.PNG

       

      The reason for this is because the first part always returns the total and doesn't aggregate on the dimension SENS:

      See: when I choose as a dimension:

      Sens&' / '&

      $(=Count({<$(vSetPeriodPres),Code_Ligne={'MAL'},Groupe_Complet_Vide={c,C,G}>}Dossier))

       

      It will show 121, which is the total:(32+89)

      Capture.PNG

       

      The question is, how to force this o return 89 for Sens N-S and 32 for S-N?

      I also tried this:

      =Sens&' / '&

      Aggr($(=Count({<$(vSetPeriodPres),Code_Ligne={'MAL'},Groupe_Complet_Vide={c,C,G}>}Dossier)),Sens)

      But this did not change a thing !

       

      Thanks in advance for your help