2 Replies Latest reply: Jul 28, 2016 10:11 AM by Azmina Virani RSS

    End of Month for Current Month Last 30 day.

    Azmina Virani

      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?