How to make now to be dynamic in the date > now-1M

i am trying to create last month sales lens

where i have added the filter of the date >= now-1M/M AND date < now/M

so lets i am in oct then i want to see sep sales.

and if i change the end from above globla time filter then the now should automatically change

#elastic kibana lens #fitler

Hi @kishorkumar

Lens has the relative time shift feature which helps you compute aggregations on a previous period of time providing a relative shift.

You can find the time shift for each metric dimension in Lens within the Advanced section of the configuration panel:

Pick any value from the selection list or just type any valid time shift:
Screenshot 2024-10-16 at 09.28.41

1 Like