7 Replies Latest reply: Mar 1, 2016 11:01 PM by PAUL YEO RSS

    How to convert my chart rEVENUE Amt by month ( 1 Line chart ) to 2 line using only 1 expression for eask compare CY vs LY ?

    PAUL YEO

      Hi All

       

       

      Chart 1 is good. Because only 1 expression & expression is very shot , it can plot 2 line. Expression as below :-

       

       

      Sum(

      {<Year={'>$(=year(today())-2)'}>}

      sales)

       

       

      Chart 2 is working fine too , but i like it present like chart 1 format. So that i can easily compare with LY trend. Chart 2 Expression as below :-

       

       

      sum({<rEVENUE={"rEVENUE"}>}Amount)

       

       

      My imagine of the final expression ( chart 3 )as below :-

       

       

      Sum(

      {<Year={'>$(=year(today())-2)'}>}

      {<rEVENUE={"rEVENUE"}>}Amount

      )

       

       

      How to make chart 3 display format same as chart 1 ? by not display 2014 line ? ( Take note that Chart 1 only display 2015 and 2016 line )

       

       

      Paul