7 Replies Latest reply: Jul 20, 2015 12:52 PM by Mike Fitzgerald RSS

    Line Chart - Divide Values for all Dates by a Value from ONE Date

      Hi,

       

      I am trying to create an indices within a line chart by dividing the values at all dates by a value from a particular date.

       

      I was thinking this would be easy. I tried:

       

      (Avg( MyValue) / Avg({1<MyDateField={"SpecificDateString"}> MyValue)*100

       

      This equation is plotted across a chart with MyDateField as the dimension.

       

      The equation works fine at the point of the SpecificDateString (eg "2009-01-09") however no other values plot on the chart. I assume this is because the chart MyDateField dimension is being selected by the measure expression to the SpecificDateString point and so no other values show.

       

      How can I make the values show for all the dates while being divided by the value from the specific date?

       

      Thank you in advance for any help. This has been a real sticking point for me!