5 Replies Latest reply: Nov 5, 2015 5:10 AM by kushal chawda RSS

    Till last month data

    Kumar Pramod

      Hi all,

       

      I am trying to display the data till end of the last month in line chart.

       

      but it is printing the value of this month also. Please help on it.

       

      Dimension:

      if((Month(CanonicalDate)),Date(MonthEnd(CanonicalDate), 'MM/DD/YYYY'),NULL())

       

       

      Measures:

      1. Count({$<DateType={'accessed'}>}invitation_id)

      2. count({$<user_signed={1},DateType = {'signed'}>}user_signed)

       

      Regards,

      Pramod