Get more than 18 colors in color pallate

[snehatopre]

Hello,

I am having a requirement where, I have more than 18 distinct values for whcih i am showing color legend. But now as more than 18 values so color for the dimension is repeating. I don't want repeated colors for different dimension value.

So to give example:

In this graph the orange color marked is showing two different manufacturer.

So I want to every manufacturer different color. How can I do that?

Thank you in advance for the help.

[prieper]

Choose Persistant Colors

[prieper]

[micheledenardi]

Add this field to the table of "Manufacturer" dimension.

Rgb(round(Rand()*(255 ),1),round(Rand()*(255 ),1),round(Rand()*(255 ),1))  AS myRandomRGB

and then use it to specify the Backgorund color inside the expression

[micheledenardi]

You can also symply use

Rgb(round(Rand()*(255 ),1),round(Rand()*(255 ),1),round(Rand()*(255 ),1))

on you chart expression background.

[snehatopre]

Thank you Michele for a solution. I have applied it. But now what I am getting is, in legend I am seeing different color for a specific manufacturer and in actual graph the there are some other set of colors for particular manufacturer.

I am getting what going on here.

Do you know the fix?

[marcus_sommer]

I think a color-expression like the following will be more suitable to create multiple colors:

= colormix1(mod(rowno(), 3) / 4, color(rowno()), if(rowno() < 12, red(), blue()))

Whereby I'm not sure if it's really a good idea to use such many different colors because many people couldn't really differ these various colors and a repeating of them (with a visible description that the colors after 18 items are repeating) could give a better user experience.

Beside them the use of such many dimension-values within a chart with visible items, a legend and scrollbars isn't very user-friendly - often there are better possibilities to visualize the information to the users.

- Marcus