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.


      Regards.