Create dta from last 3 days

aaniqshaf

I want to create data for last 3 days. Example:

If Nike start date is on 2021-07-13 and the ticket creation yes then it will npt calculate after the next 3 days and will appear back on fourth days which on 2021-07-16 if teh ticket creation yes. So right now, i want ot generate data that create last3 days and just take current month data without taken previous month data (Example : dta from 5 month ago)

Date.png

apathetichell

I'm not quite sure what you want - but you can generate the last 3 days give a start date in proper formatting via generate rows.

create a new date field (but keep RowCount as the name for now)

initial value is [start date]

condition is

RowCount >= datetimeadd([start date],-4,"days")

increment is:

datetimeadd([RowCount,-1,"days")

That will create days counting backwards using generate rows.