End of Month for Current Month Last 30 day.

[#1]

I have a variable-

v30Today = Date(Today()-30);

To calculate my last 30 days count I am doing this in my KPI:

count ({$<[Transaction Date] = {">=$(v30Today)"}, Month= , Year = , MonthYear= , WeekDay=>} DISTINCT  ACCOUNT_ID)

Current month is July.

I want to create a line chart that looks at Distinct count for each month. But for current month I want it to caclulate last 30 days. Is this possible?

[andrespa]

Hi Azmina, do you have your data at day level?

[#3]

Yes I do.