How to get data for different periods.

[#1]

Hi, how can i get data for different periods,

last day ,

last 7 days,

last month complete.

this year.

[sunny_talwar]

I am guessing you want this in the front end, right? Use set analysis with variable. Do you have a specific dataset you want us to help you with?

[Pulkit_Thukral]

For Last Year - Call_Year={"$(=DATE(FLOOR(YearStart(Today())),'YYYY'))"}

For last 7 days - ,Call_Date={">=$(=Date(today()- 6))<=$(=Date(today()))"}

[Pulkit_Thukral · Accepted solution]

For last 1 day - ArrivalDate={'$(=Date(today()-1))'}