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
<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>
This might be caused by a typo:
Type strftime instead of stftime in your eval expressions.
This might be caused by a typo:
Type strftime instead of stftime in your eval expressions.
Once again, you solved my problem. Thank you, I spent too many hours going in circles on this. It was just a typo!