topic Re: How to Set Earliest and latest in Query in Dashboards & Visualizations

How to Set Earliest and latest in Query

shugup2923 — Thu, 05 Mar 2020 12:33:18 GMT

I have a query in a dashboard, which needs to be run from 15th of last month to 14th of current month, how can I set this timerange in my query so whenever it runs it takes timerange between 15th of last month to 14th of current month.

for ex-
Time Range for running the query should be (2/15/20 12:00:00.000 AM to 3/14/20 12:00:00.000 AM)

Re: How to Set Earliest and latest in Query

gcusello — Thu, 05 Mar 2020 12:36:54 GMT

Hi @shugup2923,
Try

earliest=-mon@mon+14d+12h latest=@mon+13d+12h

Ciao.
Giuseppe

Re: How to Set Earliest and latest in Query

shugup2923 — Thu, 05 Mar 2020 13:28:15 GMT

thanks , it worked. this is a good way to give time. Thanks so much.

Keep Splunking 🙂