6 Replies Latest reply on Jan 23, 2018 7:10 PM by Shinichiro Murakami

    Add vertical reference line to where average line intersect with plotted line

    Tommy xu

      Hello community,

       

      I have a question regarding the reference line, I would like to add another reference line to an intersection of an existing reference line and plotted line, please see below

       

       

      basically I need a vertical line at where horizontal line and orange line meets(at 7.774), and indicate the x axis label

       

      I am using the below formula to find the x label which is Month,

       

      if WINDOW_AVG(sum([Cash management]))=AVG([Cash management]) then MIN([#Th Week]) end

       

      and:

       

      window_max([Month = Average]), and then added to detail, created a reference line as below:

       

       

      However the vertical line shows wrong month: the max month in the X axis.

       

      Can anyone help?

       

      Thanks!