Dashboards & Visualizations

Splunk Charting Data Based on Type

naralkar
Engager

I have derived data from Splunk in the following format (Actual Format). But I want to format furthermore it in such a way that I can see which items are present in which categories, and which are missing (Expected Format). I am trying to chart it based on categoryID, but it's not working for me as I do not think max function is appropriate for this. Can anyone please help me know how can I achieve this

Tried using

| chart max(itemId) over itemId by categoryID

Expected Format

Expected FormatExpected Format

Actual Format 

Actual DataActual Data

Labels (1)
0 Karma
1 Solution

to4kawa
Ultra Champion
| makeresults count=30
| eval categoryID=mvindex(split("Strategy,Archade",","),random() % 2)
| eval itemId="EST-1".(random() % 9 + 1)
| rex "(?<Comment>(?# this is your actual result, check this. 
from here, the logic))"
| xyseries itemId categoryID itemId

View solution in original post

to4kawa
Ultra Champion
| makeresults count=30
| eval categoryID=mvindex(split("Strategy,Archade",","),random() % 2)
| eval itemId="EST-1".(random() % 9 + 1)
| rex "(?<Comment>(?# this is your actual result, check this. 
from here, the logic))"
| xyseries itemId categoryID itemId

naralkar
Engager

Thanks @to4kawa . This was all I needed.. 

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...