topic How to create pie charts with column values? in Splunk Search

How to create pie charts with column values?

ktanwar — Mon, 03 Oct 2022 08:41:35 GMT

Hi guys, I am quite new to the Splunk world, pls forgive me for asking a very basic question.

So I have a table as following:

job_id total_passed total_failed total_not_run

9 14 20 6

10 25 31 9

and so on. I want to create a pie chart for different job_ids (lets say 9), with total_passed, total_failed, total_not_run values (14, 20, 6) and total_passed, total_failed, total_not_run as the headers of the chart in Splunk dashboard. how to do it? any help will be deeply appreciated.

Re: Create Pie charts with column values

bowesmana — Mon, 03 Oct 2022 01:56:14 GMT

So, if you're only looking to show a pie chart for a single job_id, then you could do this

The first part up to the '| table..' is creating your example.

The 'where' statement is just filtering only job_id 9

and the transpose statement converts columns to rows, so you will have 3 rows with the names/values and then the pie chart will look like this

bowesmana_0-1664762154372.png

Re: Create Pie charts with column values

ktanwar — Mon, 03 Oct 2022 03:41:03 GMT

Thanks a lot @bowesmana. Tried it, works like a charm!

1 follow up question on this, how can I change the colour of the pie chart sections and the name of the fields shown on the pie chart section (instead of total_passed, I would like to see Total Passed).

Thanks a lot mate for helping me out here!

Re: Create Pie charts with column values

bowesmana — Mon, 03 Oct 2022 23:15:47 GMT

Here's an example dashboard showing the rename and setting the colours.

In the XML you can see charting.fieldColors option to set the colours

<dashboard>
  <label>tst1</label>
  <row>
    <panel>
      <chart>
        <search>
          <query>| makeresults
| eval _raw="job_id     total_passed        total_failed      total_not_run
9                14                           20                         6
10              25                            31                        9"
| multikv forceheader=1 

| table job_id total_passed total_failed total_not_run
| where job_id=9 
| rename total_passed as "Total Passed" total_failed as "Total Failed" total_not_run as "Total not Run"
| transpose 0 header_field=job_id</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="charting.chart">pie</option>
        <option name="charting.drilldown">none</option>
        <option name="refresh.display">progressbar</option>
        <option name="charting.fieldColors">
          {"Total Failed": 0xFF0000, "Total not Run": 0xFF9900, "Total Passed":0x009900, "NULL":0xC4C4C0}
        </option>
      </chart>
    </panel>
  </row>
</dashboard>

Re: How to create pie charts with column values?

ktanwar — Tue, 04 Oct 2022 05:38:02 GMT

Thanks @bowesmana !