I have a Dimension [ORG] that contains the different organization in my work area, one of them is HR. I have an associated file that designates standard colors in RGB format that I use to designate colors in graphs for each organization.
When [ORG] is a dimension in the plot, and the expression like sum(hours), I use a series of if statements, if([ORG]='HR', RGB(ORED,OGREEN,OBLUE), as the Background color expression to set the color for each [ORG].
My current quandary... I'm setting the Expression label equal to Organization's name, e.g. HR, each expression in the plot finds the number of people in that Organization, count({<ORG={'HR'}>}DISTINCT NAMES). I'd like to keep the colors consistent with the plots using [ORG] as a dimension. How can I link the Expression name, HR, to the color codes associated with [ORG] = 'HR'
Thanks.
.png "Former Employee"){kind=icon}
