topic Xaxis data not showing up in a bar chart in Dashboards & Visualizations

Xaxis data not showing up in a bar chart

sarithapguptha — Mon, 08 Jun 2020 00:13:22 GMT

Hi,

Please help, I want to get the xaxis values in a bar chart.
In the image attached, i have a query which doesnot have transpose command where I can see the values appearing for xaxis then when i tried to change the color for each bar using transpose command then suddenly the xaxis values does not appear.
In the query i m displaying top highest 10 values

Re: Xaxis data not showing up in a bar chart

niketn — Tue, 23 Jun 2020 07:24:06 GMT

@sarithapguptha if you need color by each resource value as well as display the resource name in the x-axis, you should use | eval {resource}= cost after head 10, instead of using the transpose command.

Following is a run anywhere example for you to try out.

index=_internal sourcetype=splunkd log_level=INFO cumulative_hits=* | stats sum(cumulative_hits) as cost by name | sort - cost | head 10 | eval {name}='cost' | fields - cost

Re: Xaxis data not showing up in a bar chart

sarithapguptha — Tue, 07 Jul 2020 06:17:29 GMT

@niketn

Thank you for the solution... it worked 😊