Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
bskemp01
Contributor III
Contributor III

Color expression needed for Measures

Hello all,

i have a combo chart and i have several lines. here are the measures for a couple as an example:

Measure 1: count({<[Order Type]={'T'},[Bucket]={' > 0'}>} Distinct DocumentKey)
Measure 2: count({<[Order Type]={'S'},[Bucket]={' > 0'}>} Distinct DocumentKey)

i want to have a color expression that i can use with all the measures and itll look for the conditions above. example:

if( [Order Type]='T' and Bucket=' > 0', RGB(128,0,0) etc...

but this is looking for selections to be made in the app for these colors to apply. Does anyone know how to make the color expression in a combo chart look at the line measure and check for these conditions?

Labels (3)
1 Reply
rubenmarin

Hi, it looks like you want to color each measure in a specific color, for that you can use master items to create the measure, assign a color t the master item measure, use the master item on the chart and set it to auto or to use library colors.