Splunk Search
Highlighted

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

Explorer

Hi

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.
0 Karma
Highlighted

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

SplunkTrust
SplunkTrust

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
0 Karma
Highlighted

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

Legend

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)

0 Karma
Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.