topic Re: Sorting Multivalue Stacked Bar Chart in Splunk Search

Sorting Multivalue Stacked Bar Chart

aaronkorn — Wed, 19 Dec 2012 22:01:12 GMT

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

Re: Sorting Multivalue Stacked Bar Chart

lguinn2 — Thu, 20 Dec 2012 05:46:43 GMT

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...

Re: Sorting Multivalue Stacked Bar Chart

aaronkorn — Thu, 20 Dec 2012 13:14:41 GMT

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..

Re: Sorting Multivalue Stacked Bar Chart

lguinn2 — Thu, 20 Dec 2012 18:44:55 GMT

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