21 Replies Latest reply: Aug 11, 2016 7:40 AM by Supriya R RSS

    Showing negative values in Year over year by month

    Supriya R

      Hi all,


      I want to show a line graph where it displays  Year over year by month  of  count of invitations.


      I want to show graph for previous and current year.


      I have tried with


      Dimension : year and Month

      Expression :


      count({<DateType = {invitation},Year = {$(=max(Year))}>}invitation_id)-count({<DateType = {invitation},Year ={$(=max(Year)-1)}>}invitation_id)

      I think there is wrong in my expression.So it is showing negative values  I have attached qvf file .

      Please help me in this regard.Any kind of help is appreciated.