Splunk Search
Highlighted

Sorting Multivalue Stacked Bar Chart

Splunk Employee
Splunk Employee

Anyone have an idea to sort a multivalued stacked bar chart based on the value? I already tried | sort -Size.

The search is: index=sccm Size>0 | chart avg(Size) by Directory, SiteCode

0 Karma
Highlighted

Re: Sorting Multivalue Stacked Bar Chart

Legend

Hmm, if you want to add up the average sizes of the SiteCodes and sort by the total, you will need to know the values of the site codes. For my example, I will ensure that the values of the site codes all begin with "SiteCode:"

index=sccm Size>0 
| eval SiteCode = "SiteCode:" + SiteCode
| chart avg(Size) as AvgSize by Directory, SiteCode
| addtotals fieldname=TotalAvg SiteCode*
| sort -TotalAvg
| fields - TotalAvg

I may not really understand the question, though.

And I do question the statistical validity of any chart that sums (or stacks) averages...

0 Karma
Highlighted

Re: Sorting Multivalue Stacked Bar Chart

Splunk Employee
Splunk Employee

We are not applying a sum to the site code. The site code simply acts as an identifier for different sources of data. The point of this graph is to show the average directory size per SiteCode to notice size differences..

0 Karma
Highlighted

Re: Sorting Multivalue Stacked Bar Chart

Legend

Okay, based on your post, I would run the search this way:

index=sccm Size>0 
| chart avg(Size) as AvgSize by SiteCode
| sort -AvgSize
0 Karma