Dashboards & Visualizations

Enhance Trellis chart with text from a lookup

jhuysing
Explorer

I have a search from which i produce a trellis of  the sum of various error codes from multiple machines 
I would like to enhance the charts  with a short description of text.
I  could  add the text to the code value  and create a new  value name  and do the split on the new  "codetext".
But, then I can't use the drill down  feature.

Is there another way to add some text to the individual graphs

Labels (3)
0 Karma

jhuysing
Explorer

I have been fiddling around trying to us a eval to strip the phrase from the passed  value

With no luck

0 Karma

yuanliu
SplunkTrust
SplunkTrust

Not sure what you are trying to express.  This is what YOU come up with

| rex field=Error_Text".*:\s(?P<Code>\d{3})"
| lookup error_codes Code OUTPUT Phrase
| eval CodePhrase = Code+" -- "+Phrase

Does this add Phrase to your trellis label or not?  I bet this does.  If it does, what's wrong with this method? 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Why can't you use the drilldown feature?

0 Karma

jhuysing
Explorer

Sorry been busy with other work

Maybe I  am doing this wrong
The only way I could figure out how  give a bit more information in  a graph was  to  join the code  and phrase and then use that in the Split By in the Trellis

| rex field=Error_Text".*:\s(?P<Code>\d{3})"
| lookup error_codes Code OUTPUT Phrase
| eval CodePhrase = Code+" -- "+Phrase


When I use the Drill down it using joined  "codephrase"  field.

So I am wondering if there is another way to add the text  to  the graphs

0 Karma

yuanliu
SplunkTrust
SplunkTrust

Is there anything wrong with the method you already use?  Or is there a specific effect this is not giving you?

If you think it through, trellis has only one single variable for breakdown and display.  All you can do is to change this value.  You search already does that.  If it ain't broken and disclaimers😃

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...