topic Re: Can't display x value when there are too many columns? in Dashboards & Visualizations

Can't display x value when there are too many columns?

kennethyeung — Tue, 03 Oct 2017 03:57:56 GMT

Hi All,

I found out when the dashboard have too many col in the chart, cannot display the x value,

Can we make the chart larger to display?

Re: Can't display x value when there are too many columns?

xisura — Tue, 03 Oct 2017 04:16:03 GMT

Can you share your search query here ?
you can try to add limit =0 to show all the results
ex. |chart count by sourcetype limit=0

Check this out:
http://docs.splunk.com/Documentation/SplunkCloud/6.6.3/SearchReference/Chart#Chart_options

Re: Can't display x value when there are too many columns?

niketn — Tue, 03 Oct 2017 05:29:01 GMT

@kennethyeung, what is the field on x-axis? What is your transforming command? Which is the chart visualization you are using? How many data points do you have on x-axis? Do you have single chart in one row or more?

Please add more details so that community members can assist you with your use case.

Re: Can't display x value when there are too many columns?

cmerriman — Tue, 03 Oct 2017 12:00:07 GMT

there are limitations to charts that when they have too many data points, the axis will either start grouping and only showing a few, or might disappear. it depends on what format the axis is in and how many data points there are, etc. More information would be helpful, such as a snippet of the xml/spl. thanks.

Re: Can't display x value when there are too many columns?

kennethyeung — Wed, 11 Oct 2017 00:53:25 GMT

| sort-"Number of Late"
| table "Name","Number of Late"

Now, i divided into 2 graph, (search)
1 search for more than 5 and another less than 5. if possible, want to use 1 graph to display all record.