topic Re: color a pie chart slice in Dashboards & Visualizations

color a pie chart slice

autoteam — Wed, 30 Sep 2020 12:18:04 GMT

Hello,

I have a pie chart that shows me the count of all the alerts I get on my system, stats by severity.

Because I couldn't find a way to show the count (only the percentage) then I changed the name so it will contain both the severity name and the count (used eval function).

before I changed the name I used charting.fieldcolores to set a specific color to each severity(slice), now that the name constantly changing because the count is changing I wasn't able to set a color to each slice.

I tried using charting.seriescolors but when I use that I cant determine that the critical severity will always get a red color and the warning gets orange and so... because the color is not set to a specific slice.

I wanted to ask if there is a way I can set the colors regularly to a name when I don't have the full name of the slice, maybe using a (*) like- "Critical*" and then the slice that contain the word critical will always color in red?

If it is not possible, is there a way to show the count and not the percentage! without using eval and changing the slice name?

all answers will help!

thanks!!!

Re: color a pie chart slice

isoutamo — Wed, 30 Sep 2020 16:16:58 GMT

Hi
Can you try this: https://community.splunk.com/t5/Archive/How-to-assign-fixed-colors-to-pie-chart-with-dinamic-legend/m-p/447033
r. Ismo

Re: color a pie chart slice

autoteam — Thu, 01 Oct 2020 10:12:43 GMT

Hi,

As I understand from the answer I still have a problem since I can't ensure that all the labels will stay present because when the value is 0 it is absent. this is one of the things that bothered me with the seriescolor...

In addition I want to keep the count in the label name not to change it. I saw they used eval in the answer.

what can I do with those cases?

thanks again!!!

Re: color a pie chart slice

isoutamo — Thu, 01 Oct 2020 10:14:45 GMT

When you are using seriesColors it's not matter what labels you have. Only thing what you must ensure is the order and amount of those fields. That must be always fixed.
r. Ismo

Re: color a pie chart slice

autoteam — Thu, 01 Oct 2020 10:17:40 GMT

Ok, so how can I ensure that?

I tried setting the colors in the seriescolors by the order of the labels but sometimes the changed when I had a value of 0 and that's when my problem started...

Re: color a pie chart slice

isoutamo — Thu, 01 Oct 2020 10:19:51 GMT

From @niketn 's response:

The command after |append ensure all series are always present and in the same sequence so that seriesColors can be applied. While testing you can randomly take out specific series like status=\"Progress\",count=10; to test that it creates a Process row with 0 count and 0%. Please try with seriesColors and confirm!

Can you do it like this?

r. Ismo

Re: color a pie chart slice

autoteam — Thu, 01 Oct 2020 10:37:30 GMT

I will try first thing first on Sunday an let you know!

thank you so much!!

Re: color a pie chart slice

autoteam — Sun, 04 Oct 2020 14:10:08 GMT

It worked! thank you so much!