9 Replies Latest reply: Sep 16, 2014 1:34 PM by Oscar Marquez RSS

    Two years in same chart by day?

    Oscar Marquez

      Hi all, hope you can help me, I have a line chart that has a date as dimension which is already in format MMM-dd in load script. I'm showing the current count based on selections and I want to add a second line with last year data at same dates but something is not working, the chart split the dates as if they had a year, see the example.

       

      Capture.JPG.jpg

      here are my expressions:

      CY: =count(if(Source='Letters',[Sales Letter ID]))

      LY: =count({<FY={$(=FY-1)}>}  if(Source='Letters',[Sales Letter ID]))

       

      PS: The lines looks the same because is dummy data for CY, which is ok.