Dashboards & Visualizations

Dashboard timechart query problem

rbochen
New Member

How do I present ONLY "allErrorsPerMile" on a timechart? Now it looks like on the attachment

 "exception1" OR "exception2" OR "exception3" OR "call"
        | eval calls = if(like(message, "%call%"), 1, 0)
        | eval errors1 = if(like(message, "%exception1%"), 1, 0)
        | eval errors2 = if(like(message, "%exception2%"), 1, 0)
        | eval errors3 = if(like(message, "%exception3%"), 1, 0)
        | timechart sum(errors1) AS errors1 sum(errors2) AS errors2 sum(errors3) AS errors3 sum(calls) AS calls 
        | eval allErrorsPerMile=if(calls>0, ((errors1 + errors2 + errors3)*1000)/calls, calls = 1)

alt text

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

Hi

Can you please try this one?

 "exception1" OR "exception2" OR "exception3" OR "call"
         | eval calls = if(like(message, "%call%"), 1, 0)
         | eval errors1 = if(like(message, "%exception1%"), 1, 0)
         | eval errors2 = if(like(message, "%exception2%"), 1, 0)
         | eval errors3 = if(like(message, "%exception3%"), 1, 0)
         | timechart sum(errors1) AS errors1 sum(errors2) AS errors2 sum(errors3) AS errors3 sum(calls) AS calls 
         | eval allErrorsPerMile=if(calls>0, ((errors1 + errors2 + errors3)*1000)/calls, calls = 1)
| fields _time  allErrorsPerMile

I have just added "| fields _time allErrorsPerMile".

Thanks

0 Karma

rbochen
New Member

did it with charting.data.fieldHideList

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 ...