Chart custom colors

Magnus_Lundgren1Magnus_Lundgren1 Customer IT Monkey ✭
Hi.

I just upgraded to 7.3 and have been fidling around with the new stacked charts.
I saw that one of the OOB once have a CASE WHEN
This looks like it would set the color of Incidents to be orange, SR to green etcetc. But its not, is this possible or is the example something for future features...

,CASE WHEN ClassId = 'E6C9CF6E-D7FE-1B5D-216C-C3F5D2C7670C' THEN '#2980B9'WHEN ClassId = 'A604B942-4C7B-2FB2-28DC-61DC6F465C68' THEN '#E67E22'WHEN ClassId = '422AFC88-5EFF-F4C5-F8F6-E01038CDE67F' THEN '#C0392B'WHEN ClassId = '04B69835-6343-4DE2-4B19-6BE08C612989' THEN '#2ECC71'WHEN ClassId = 'd02dc3b6-d709-46f8-cb72-452fa5e082b8' THEN '#8E44AD'

Answers

  • Geoff_RossGeoff_Ross Cireson Consultant Super IT Monkey ✭✭✭✭✭
    Hi Magnus,

    I think that is left over from the old Dashboard page where the dashboards we're defined in JavaScript and pie chart colour could have been used. When the dashboard pages were 'Up-cycled' to Analytics pages, the same SQL queries were used. There's no way to set the colour in the current Analytics product.

    However, good spot and please go ahead and raise a feature request as I would 100% vote that up and this would be the way to do it. To return hex colour values in the Query and then just pick a column that contains the colour.

  • Stephane_BouillonStephane_Bouillon Customer IT Monkey ✭
    I upgraded to 8.2 recently. Is there a way to set the color of the columns of a chart where items are grouped by date to one and the same ? As it stands every column has a different color. For example number of Created items on that day in blue and number of closed items in red ?

    Stephane
Sign In or Register to comment.