Dashboards & Visualizations

How do you display the time range from a report in a dashboard panel?

DEAD_BEEF
Builder

I have a scheduled report that runs everyday at 02:00 AM and gathers statistics for the previous day in a nice table. I have this report displaying the table as a panel in my dashboard.

How do I go about referencing the earliest and latest time of the report in the dashboard panel's title?

Below is what it looks like now and the XML for my dashboard panel

alt text

 <panel>
      <title>This panel powered by scheduled report</title>
      <table>
        <title>Data from $earliest_token$ to $latest_token$</title>
        <search ref="Scheduled Report Test">
          <done>
            <eval token="earliest_token">stftime( relative_time( now(), $job.request.earliest_time$ ),  "%c" )</eval>
            <eval token="latest_token">stftime( relative_time( now(), $job.request.latest_time$ ),  "%c" )</eval>
          </done>
        </search>
        <option name="count">7</option>
        <option name="drilldown">none</option>
      </table>
    </panel>
0 Karma
1 Solution

whrg
Motivator

This might be caused by a typo:
Type strftime instead of stftime in your eval expressions.

View solution in original post

whrg
Motivator

This might be caused by a typo:
Type strftime instead of stftime in your eval expressions.

DEAD_BEEF
Builder

Once again, you solved my problem. Thank you, I spent too many hours going in circles on this. It was just a typo!

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...