topic Re: Force multiple colour per category in Pie Chart in Dashboards & Visualizations

How to make multiple colour per category in Pie Chart

POR160893 — Tue, 07 Jun 2022 15:01:53 GMT

Hi,

I need to create a pie chart .... however, the query sets all BOTH categories the SAME colour.

How can I make them different?

Thanks

Re: Force multiple colour per category in Pie Chart

ITWhisperer — Tue, 07 Jun 2022 12:53:22 GMT

You have a Completion Status value of an empty string - this is not the same as a null value nor just a space. Convert the empty string to a space (or some other more useful value).

| eval "Completion Status"=if('Completion Status'=""," ",'Completion Status')

Re: Force multiple colour per category in Pie Chart

POR160893 — Wed, 08 Jun 2022 08:45:12 GMT

This worked 🙂

But, how can I standardize the 3 pie charts to have the same color scheme as the pie chart on the right:

The following is my code:

Many thanks as always and I have given you Karma again 🙂

Re: Force multiple colour per category in Pie Chart

ITWhisperer — Wed, 08 Jun 2022 08:55:46 GMT

Include the same charting.seriesColors option in all three charts.