Hi,
I'm trying to plot a dataset over time. Here is my query:
index=gpm AND (ExperimentStart OR runtimedatatransferstartimpl)
| eval run_name=exp
| eval transfer_start=case(_raw LIKE "%RuntimeDataTransferStartImpl%", _time)
| eval experiment_start=case(_raw LIKE "%ExperimentStart%", _time)
| eventstats min(transfer_start) AS xfer_start, min(experiment_start) AS exp_start by run_name
| eval time_to_setup=(xfer_start-exp_start)/60
| eval Time = strftime(_time, "%m/%d %H:%M")
| search time_to_setup < 500
| chart values(time_to_setup) AS "Time to setup (Min)" by Time
This allows me to plot a trendline of time_to_setup over the course of a day. The issue is that there are so many x values that no labels show up on x-axis. Looking at the chart you can see the trend over time but there's no way to see when during the day the events occurred without hovering over the chart. This report is distributed as a pdf in an email so it's not viable to have users go onto the dashboard itself to see this.
I was wondering if there was a way to simply have a marker for every two hours (12 markers across a day) so that at face value the relative time of day that the event occurred can be determined.
... View more