topic How to sort columns in chart with row-split in Splunk Search

How to sort columns in chart with row-split

lem — Mon, 21 Mar 2016 22:31:30 GMT

Hi,

I need to graph data per Area split by WeekNumber:

| chart Values by Area WeekNumber
Both - Values and WeekNuber are numbers, however WeekNmubers in the graph are sorted as if they are string type ( 10, 11, 9 instead of 9, 10, 11).

If I swap series:
| chart Values by WeekNuber Area
the WeekNumbers are sorted correctly on X-Axis (9, 10, 11).

I tried using "sort WeekNumber" and didn't have any impact on column order.

Any help is greatly appreciated.

Re: How to sort columns in chart with row-split

martin_mueller — Mon, 21 Mar 2016 22:41:14 GMT

As a mildly dirty workaround, you could use 09 as your week number - then string ordering will do what you need.

Re: How to sort columns in chart with row-split

lem — Tue, 22 Mar 2016 02:59:37 GMT

Thank you Martin, Appending zero did the trick. Wish there was a better way to do this though. Cheers!

Re: How to sort columns in chart with row-split

mikymasterlace — Tue, 18 Apr 2017 10:22:49 GMT

[OT] sorry this is not an answer, but could you tell me how to display values above the columns charts? thankyou so much!

Re: How to sort columns in chart with row-split

martin_mueller — Tue, 18 Apr 2017 17:20:22 GMT

In the chart's format menu's general tab, turn on "show data values".