Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
User_2019
Contributor

Colours using RGB values

I am setting colors based on RGB values using columns in the Brand table and then RGB(BrandR,BrandG,BrandB) in the color by dimension for bar and pie chart.

I find the bar chart colors are nearly there but not accurate while the Pie colors are closer to the codes but one color is way different! (See the fourth bar).

Is there a possible cause?

Bar coloursBar coloursPie coloursPie colours

5 Replies
y_grynechko
Creator III

Can you please provide me with 5 RGB values? 

User_2019
Contributor
Author

Thanks!

The colors (which I picked using color picker in Firefox for testing) are

 

0 57 185 (Blue)

19 103 21 (Green)

3 57 130 This is wrong on both

237 205 104 - also wrong

 

There is no fifth color, it is the system default.

 

User_2019
Contributor
Author

Just an update, it seems the version matters too. I just now upgraded to Nov 2019 version of the desktop, now all the colors are consistent and appear OK, except the second one, which appears in same wrong shade in both the charts!  Earlier that was Ok. This situation is very different from the earlier version I used (Nov. 2018 Patch 2).

Thanks!

 

y_grynechko
Creator III

Nov 2019 release: 

Used color exp(the same in both visuals):

if(ArrayValues = 7, RGB(237, 205, 104),
if(ArrayValues = 8,RGB(3, 57, 130),
if(ArrayValues = 9,RGB(0, 57, 185 ),
if(ArrayValues = 10,RGB(19, 103, 21),black()))))

Capture.PNG

User_2019
Contributor
Author

Hi thanks for your efforts. Yes, the colors in Nov 2019 are much closer to what I want. I will use them.

I am sorry for a typo but the color 19,103,21 should have been 19,103,11 which shows up as green in HTML but a strange blueish tint in QS. I will ignore that for now.