Assigned colors do not stay on refresh (solved)

Hi,

I saw several topics on colors, but I can't find this specific one.

So I have a visual, either a bar chart or a pie-chart and I want to give it fixed colors.
Like the bar with "Completed" should be green, "To Do" should be yellow.

Now I can assign colors to ranges with the color picker in both the question editor, and in the visual editor (why at both places?)
But whichever color I set, the very next time the data update (mySQL) the color changes again.
Any ideas or explanation, workarounds?
Using the on-premise version btw.

Hello there,

In pie charts each row becomes a slice, one column dictates its size (the measure) and another its color (the "inner ring"). Here the value 218 of the inner ring column is assigned to green, but if it changes this association is lost.
You need another column that determines the color and stays consistent, in your case since it's fixed, you can hard-code it to always be the same value and assign it the color green (like SELECT 'Completed', milestones_completed_today ...)

In this case it could also make sense to use a Number visualization. A pie chart usually makes more sense when there is more than one slice, like "count milestones by status", something like this for example:



1 Like

Hi marcos,

Ah ok that is very helpful. So it's just a matter of structuring the table so that you can assign color to the named range instead of the output value. Great thanks!