Dashboards & Visualizations

How to retrieve data in separate panels with single value from JAN, FEB... to DEC?

maximusdm
Communicator

Hi there
I have 12 panels in my dashboard and each panel retrieves data from each month.
Some panels will be empty since we are still in FEB month.
I am trying to get the proper values below to each month:

      <earliest>-1mon@mon</earliest>
      <latest>@mon</latest>

The help file says something about @mon1, @mon2, etc... but am not sure how to build the date string.

Thanks

Tags (1)
0 Karma
1 Solution

somesoni2
Revered Legend

Try like this

Panel for Jan:  earliest=@y        ,  latest=@y+1mon 
Panel for Feb:  earliest=@y+1mon   ,  latest=@y+2mon 
Panel for Mar:  earliest=@y+2mon   ,  latest=@y+3mon 
Panel for Apr:  earliest=@y+3mon   ,  latest=@y+4mon 
...and so on....

View solution in original post

0 Karma

somesoni2
Revered Legend

Try like this

Panel for Jan:  earliest=@y        ,  latest=@y+1mon 
Panel for Feb:  earliest=@y+1mon   ,  latest=@y+2mon 
Panel for Mar:  earliest=@y+2mon   ,  latest=@y+3mon 
Panel for Apr:  earliest=@y+3mon   ,  latest=@y+4mon 
...and so on....
0 Karma

maximusdm
Communicator

thank you!

0 Karma
Get Updates on the Splunk Community!

Get Schooled with Splunk Education: Explore Our Latest Courses

At Splunk Education, we’re dedicated to providing incredible learning experiences that cater to every skill ...

Splunk AI Assistant for SPL | Key Use Cases to Unlock the Power of SPL

Splunk AI Assistant for SPL | Key Use Cases to Unlock the Power of SPL  The Splunk AI Assistant for SPL ...

Buttercup Games: Further Dashboarding Techniques (Part 5)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...