Dashboards & Visualizations

One-dimensional bar charts

helge
Builder

I have a single row with, say, three values. I want to visualize these values using a bar chart so that the user can easiliy see the differences between the values.

However, it does not seem to be possible to display such "one-dimensional" charts. I guess I must be missing something.

Example:

This (sample) search yields one row with three values:

index=_internal source="*metrics.log" group=per_sourcetype_thruput | stats avg(kb) median(kb) min(kb)

I want it displayed similar to this.

Is that possible? If so, how?

0 Karma
1 Solution

jonuwz
Influencer

Try this :

index=_internal source="*metrics.log" group=per_sourcetype_thruput | stats avg(kb) as avg median(kb) as median min(kb) as min | untable ignore metric value | fields - ignore

or

index=_internal source="*metrics.log" group=per_sourcetype_thruput | stats avg(kb) as avg median(kb) as median min(kb) as min | transpose | rename column as metric "row 1" as value

View solution in original post

jonuwz
Influencer

Try this :

index=_internal source="*metrics.log" group=per_sourcetype_thruput | stats avg(kb) as avg median(kb) as median min(kb) as min | untable ignore metric value | fields - ignore

or

index=_internal source="*metrics.log" group=per_sourcetype_thruput | stats avg(kb) as avg median(kb) as median min(kb) as min | transpose | rename column as metric "row 1" as value

helge
Builder

Interesting, thank you!

0 Karma
Get Updates on the Splunk Community!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI! Discover how Splunk’s agentic AI ...

[Puzzles] Solve, Learn, Repeat: Dereferencing XML to Fixed-length events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Stay Connected: Your Guide to December Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...