Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to control the colors of bars in a bar chart to reflect the measure set analysis value. Any suggestions on how I do this?
This is the DATA for the Bar Chart:
Dimensions = Date
Measure 1
COUNT(DISTINCT {<Order_Status={'Recieved'}>} Order_Ref_No)
Measure 2
COUNT(DISTINCT {<Order_Status={'Ready to dispatch'}>} Order_Ref_No)
Measure 3
COUNT(DISTINCT {<Order_Status={'Delivered'}>} Order_Ref_No)
The code I would use to color by expression would be:
IF(Order_Status = 'Recieved', RED(),
IF(Order_Status = 'Ready to dispatch', YELLOW(),
IF(Order_Status = 'Delivered', GREEN(), BLUE()))
Thanks in advance!
Hello,
You can put those Measures in Master Library (Master Measures) and give custom color to each measure (bar).
Check if that works for you.
Thanks,
Ashutosh