topic Re: How to get a column chart to show all x-axis labels? in Splunk Search

How to get a column chart to show all x-axis labels?

kualo — Fri, 23 Dec 2016 17:32:54 GMT

I want to show score distribution by column chart. The score ranges from 0 to 100
I have the below search and it gives me the correct result. If I only have fewer scores it will show the score labels.
However, but it won't show all the score labels on x-axis.
Is there anyway to show all 0-100 on the x-axis?
Thanks and merry Christmas.

some search | stats count by score.

Re: How to get a column chart to show all x-axis labels?

somesoni2 — Fri, 23 Dec 2016 19:28:40 GMT

How about this? (will show 0 count for score that are not returned by your search)

 some search | stats count by score | append [| gentimes start=-1 | eval score=mvrange(0,101) | table score | mvexpand score | eval count=0 ] | stats max(count) as count by score

Re: How to get a column chart to show all x-axis labels?

niketn — Sat, 24 Dec 2016 11:39:17 GMT

I think plotting of 100 data points on x-axis is would not be possible unless you reduce browser text size to 90% or 85% or more or maybe display up to 85 data points on x-axis.

You can try some charting properties to accommodate as many data points as possible:

    <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
    <option name="charting.axisLabelsX.majorLabelStyle.rotation">-90</option>
    <option name="charting.axisLabelsX.majorLabelVisibility">show</option>
    <option name="charting.axisX.includeZero">true</option>

You can also explore Punchcard custom visualization which can plot the 100 series data in x-axis (offers 45 degree rotation for labels)