Color expression needed for Measures

bskemp01 — Wed, 19 Mar 2025 21:58:43 GMT

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?

Re: Color expression needed for Measures

rubenmarin — Sat, 01 Jun 2024 06:39:38 GMT

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.

topic Re: Color expression needed for Measures in Data Movement & Streaming

Color expression needed for Measures

Re: Color expression needed for Measures