Dashboards & Visualizations

One-dimensional bar charts

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

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

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

Builder

Interesting, thank you!

0 Karma