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




      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?