Dashboards & Visualizations

How to put Multiple labels on x-axis of bae chart?

POR160893
Builder

Hi,

I have a bar chart and I need to put multiple labels on the x-axis.

So. this is what I currently have:

POR160893_0-1657534879687.png

 



I am being asked to put the necessary label on the legend also under each bar on the x-axis .... is that possible?


Many thanks as always 🙂

0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

The random values are just part of the runanywhere example, you were supposed to look at it and find the useful pieces for your usecase. Now that you have provided an example of what you are doing, it is easier to provide a closer solution

| inputlookup Migration-Status-McAfee2.csv
| fillnull value=null
| eval dummy = 'Migration Comments'
| chart count over "Migration Comments" by dummy

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

Do you mean something like this?

| makeresults count=100
| eval state=mvindex(split("Done|In progress|Not started","|"),random()%3)
| stats count by state
| eval dummy=state
| chart values(count) as count by state dummy
0 Karma

POR160893
Builder

Yes so close, but I would be using it with a inputlookup with specific values.
When I use your example, it is not using the inputlookup even when I use it in the query.
How can I make it NOT random?

This is my original query with specific values for the 3 states in the inputlookup:
| inputlookup Migration-Status-McAfee2.csv
| fillnull value=null
| eval dummy = 0
| chart count over dummy by "Migration Comments"

So, visually it is exactly what I need but I can't have any random influence on the values.


Is this possible?

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

The random values are just part of the runanywhere example, you were supposed to look at it and find the useful pieces for your usecase. Now that you have provided an example of what you are doing, it is easier to provide a closer solution

| inputlookup Migration-Status-McAfee2.csv
| fillnull value=null
| eval dummy = 'Migration Comments'
| chart count over "Migration Comments" by dummy

POR160893
Builder

Exactly what I needed. Thanks and I obviously gave some some deserved Karma too 😁

0 Karma
Get Updates on the Splunk Community!

.conf25 Registration is OPEN!

Ready. Set. Splunk! Your favorite Splunk user event is back and better than ever. Get ready for more technical ...

Detecting Cross-Channel Fraud with Splunk

This article is the final installment in our three-part series exploring fraud detection techniques using ...

Splunk at Cisco Live 2025: Learning, Innovation, and a Little Bit of Mr. Brightside

Pack your bags (and maybe your dancing shoes)—Cisco Live is heading to San Diego, June 8–12, 2025, and Splunk ...