I am trying to get the timecards created this quarter for last quarter
I am trying to get the timecards created this quarter (Q2) but for last quarter (Q1)
the reference dates are created date(current quarter) and end date(previous quarter)
so, I have this created in beastmode>>>
(case When `TC: Created Date` >= '4/1/2021' and `TC: End Date`< '3/31/2021' then 1 else 0 end)
how can I make the dates dynamic so that I can create a graph that also shows the timecards created on Q1 but was for Q4 2020 and so on.