Dashboards & Visualizations

Please help to create a pie chart

leanpro
Engager

I have stats as below and convert this to a pie chart (2 pieces showing the count)
alt text

Tags (1)
0 Karma
1 Solution

TISKAR
Builder

Hello,

Can you try this please,

<yourSearch>| transpose 0 column_name="type" | rename "row 1" as value

For Example past this request in your bare search,

| makeresults |eval a=60, b=40 | table a b| transpose 0 column_name="type" | rename "row 1" as value

View solution in original post

0 Karma

TISKAR
Builder

Hello,

Can you try this please,

<yourSearch>| transpose 0 column_name="type" | rename "row 1" as value

For Example past this request in your bare search,

| makeresults |eval a=60, b=40 | table a b| transpose 0 column_name="type" | rename "row 1" as value
0 Karma

leanpro
Engager

Many thanks! Exactly what I needed!

0 Karma

neelamsantosh
Path Finder

on the dasbord/panel
on top u have magnifier/search |table|art brush kind of symbols
choose the table icon and "Select visualization-> select the Pie chart".

Ref: https://docs.splunk.com/Documentation/Splunk/7.0.3/Viz/PieChart
happy splunking

0 Karma

leanpro
Engager

I know that but the pie shows both the count

0 Karma

neelamsantosh
Path Finder

Obviously, as the results has 2counts.
which value do u want to show.

If you want single values , at the end of ur search "|table "
then the pie chart will show only desired field.

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...