This content has been marked as final. Show 2 replies
Hope you are doing great. Can some please help me in converting the below measure expression into 100% stacked bar.
PLANYEAR (example: 2010,2011,2012,2013....2018)
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'
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