3 Replies Latest reply: Mar 24, 2016 9:40 AM by Mehul Thakrar RSS

    Convert dimension to show lifetime trend

    Mehul Thakrar

      I have a simple line chart with Date as dimension and two expressions.  The first expression runs for a longer period than the second (as in the attached example).  What I would like to do is show them both starting at the same point under a universal date dimension (for example, month 1, month 2 etc).

       

      I have attached a QVW which highlights this.  The first chart displays the current view and the second chart the desired result.  I have manipulated the data to get the desired result but would ideally like to get to it by either changing the original chart properties or maybe even the script.  Although, a script change may affect the calendar as a whole and other data tables.

       

      I'm not sure if this is possible but am open to any suggestions!

       

      Many thanks in advance.

       

      Mehul