Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
PLEASE HELP!!! I have googled and youtubed looking for help and haven't found it....
The problem ....
Dimension - (Drill-down) Regional Training, BC , Dist, Dealer Code
Measure - Count of Students that have a "Y" status and a Count of Students that have a "N" status:
Measure 1 = Count({$<[LEVEL 1 COMPLETION]={"Y"}>} distinct SID)
Measure 2 = Count({$<[LEVEL 1 COMPLETION]={"N"}>} distinct SID)
I want to be able to write an expression (if that is the easiest way) to color by measure... N = Red and Y = Green.
It seems so simple but I can't figure it out. Please help ASAP! Thanks!
Try moving [LEVEL 1 COMPLETION] as your second dimension (so you'll have two dimensions: drilldown and [LEVEL 1 COMPLETION]), make your expression Count(distinct SID), and enter your color expression as if([LEVEL 1 COMPLETION]='Y',green(),if([LEVEL 1 COMPLETION]='N',red()))
Try moving [LEVEL 1 COMPLETION] as your second dimension (so you'll have two dimensions: drilldown and [LEVEL 1 COMPLETION]), make your expression Count(distinct SID), and enter your color expression as if([LEVEL 1 COMPLETION]='Y',green(),if([LEVEL 1 COMPLETION]='N',red()))
Can you just write in your color by expression
If([LEVEL 1 COMPLETION]='Y',Green(),Red())
THANK YOU!!!!!!!!!
It worked! You have no idea how much I appreciate your help and knowledge. I changed the color expression to - if([LEVEL 1 COMPLETION]='Y',green(),red()) but your guidance got me to where I needed to go! Huge help! You Rock!
Yes, that expression worked but I needed to first get the dimension and drill-down to be positioned correctly. Thanks for your help!
Hi,
I have tried the same colour expression:
if([AMHP Out of Hours Y/N] ='Yes',black(),if([AMHP Out of Hours Y/N] ='No',green(), red()))
However as you can see from the attached image, the expression is not working on the stacked bar chart.
The 2 Measures I have for the stacked chart are:
1) SUM({<[AMHP Count Referral]={1}, [AMHP Out of Hours Y/N] ={'Yes'}>} [AMHP Count Referral])
2) SUM({<[AMHP Count Referral]={1}, [AMHP Out of Hours Y/N] ={'No'}>} [AMHP Count Referral])
Thanks,
Lav