2 Replies Latest reply: Feb 23, 2018 5:54 PM by vidya sagar malla RSS

    100% Stacked Bar for Count Unique Products

    vidya sagar malla

      Hi All,

       

      Hope you are doing great. Can some please help me in converting the below measure expression into 100% stacked bar.

       

      Dimension1:

      PLANYEAR (example: 2010,2011,2012,2013....2018)

       

      Dimension2:

      =

      if(WildMatch(MORNINGSTARCATEGORY,'*Target*') and TRPFUNDINDICATOR=1,'Plans Using TRP RDFs',

      if(WildMatch(MORNINGSTARCATEGORY,'*Target*') and TRPFUNDINDICATOR=0,'Plans Using NON TRP RDFs',

      if(IsNull(MORNINGSTARCATEGORY) and TRPFUNDINDICATOR=0 ,'Empty Values',

      'Plans Without RDFs'

      )))

       

       

      Measures Expression:

      count(distinct PLANNAME)


      With this expression, i am getting right count. But when I trying to convert this 100% I am not getting right results.



      The expression I tired :

      count(distinct PLANNAME) / count(distinct TOTAL <PLANYEAR> PLANNAME)


      Result I am getting is


      100% Percentage Stacked for unique plans.PNG

       

      Thanks,

      -Vidya