topic Re: Multiple Colours for Chart Expressions in App Development

Multiple Colours for Chart Expressions

JamGardner — Wed, 29 Mar 2023 15:24:36 GMT

Hi All,

I am building several different apps where I want to display various metrics that belong to different areas. These areas all have their own set of colour associated with them, a type of brand recognition.

Normally if it was one measure I would just use an if statement, saying if Dept a use RGB(20,500,00) if Dept b use RGB(100,200,10) etc.

However with charts with multiple measures I use custom colours with Hex codes in the chart i.e. ='#00504c,#54670,#11211'.

Is there any way to combine them both, so that if an end user selects dept A on a filter the metrics will adjust the colour code to that dept for easy recognition.

Thanks, I've not seen this before and I am fully expecting it to be a "nope" but thought I would ask in the hope.

Re: Multiple Colours for Chart Expressions

brunobertels — Wed, 29 Mar 2023 16:37:55 GMT

May be regarding this questions :

Is there any way to combine them both, so that if an end user selects dept A on a filter the metrics will adjust the colour code to that dept for easy recognition.

somethink like that in color dode panel :

If(getfieldselection(Dept)='A', colorcodefordeptA, if(getfieldselection(Dept)=B,colorcodefordeptB)) etc

Re: Multiple Colours for Chart Expressions

JamGardner — Thu, 30 Mar 2023 08:51:55 GMT

Amazing, Thanks!