topic Re: color measures in Integration, Extension & APIs

color measures

Anonymous — Sun, 19 Nov 2017 16:27:10 GMT

Hi Expert,

there are three columns

col1 col2 col3 col4

a 1 4 n

b 2 5 n

c 3 6 n

d 4 7 y

it is bubble chart and i am getting three colors for different measures when i set the expressions colors by measures

but i want set color specifcally y condition value to some other color for an example

col3 values 4567 has differnt colors so want some differnt color based y conditon but unable to do it if condition

i.e. when i tried if col4 ='y' the char(9899) but it is changing all bubble color

i only want above condition color change rest remain same

thanks

Re: color measures

rubenmarin — Sun, 19 Nov 2017 19:29:47 GMT

Hi Rupesh, i'm not sure to understand your needs, attached is example coloring one bubble based on col4 condition.

Re: color measures

Anonymous — Mon, 20 Nov 2017 01:57:54 GMT

Hi Ruben

it should also refer to colo2 and col3 color where in this case only two colors appear.it should be three colors

If(col4='y', Red(), Blue())

thanks

Re: color measures

Anonymous — Mon, 20 Nov 2017 07:54:33 GMT

Hi Expert,

Any suggestions on this logic

Re: color measures

rubenmarin — Mon, 20 Nov 2017 08:48:40 GMT

Hi Rupesh, I don't understand the requirements, what conditions should apply for col2 and col3? can you a post an image of the required result?

Re: color measures

Anonymous — Mon, 20 Nov 2017 08:51:55 GMT

col2- red

col3 green

if col4 is y then blue only this row d 4 7 y rest remain same

Re: color measures

rubenmarin — Mon, 20 Nov 2017 08:54:56 GMT

Color are assigned by dimension values (rows), you can use the other columns to filter based on it's values, not for the entire column. there is always a value for col2, so it will be always red?

Have you chechked my sample? is that the kind of chart you are using?

Re: color measures

Anonymous — Mon, 20 Nov 2017 08:59:04 GMT

can we change color for only one row

col2- red

col3 green

if col4 is y then blue only this row d 4 7 y (only one row to be blue that sit) rest blue and green are also required

Re: color measures

rubenmarin — Mon, 20 Nov 2017 09:02:28 GMT

That's what my sample does, have you cheched?, it only changes the color for d, wich has col4='y'

Again: col2 and col3 are values of the same row, it can't have different colors based only on column, it needs a vlue to check as it's done with col4, checking if it has 'y' or not. what is ned to check in col2 and col3?

Re: color measures

Anonymous — Mon, 20 Nov 2017 09:06:44 GMT

no sir, I am getting only 2 color blue and red col3 green is overlapping to blue for entire column

Re: color measures

Anonymous — Mon, 20 Nov 2017 12:45:07 GMT

there is requirement like this for colors they need 3 colors

Re: color measures

rubenmarin — Mon, 20 Nov 2017 12:50:49 GMT

You can set color to col1, based on condition of the values of col2, col3 and/or col4.

You need some conditions to check on col2 and col3 to assign the other colors.