7 Replies Latest reply on Jan 9, 2017 2:37 PM by Yuriy Fal

    Reference Line with Calculated Field, Filtered by Dimension on Scatter Plot

    Jingwei Teng

      Hi

       

      I've currently created a reference line for a scatter plot with customized static data using a parameter but would like the reference lines to update on its own. I.e. if I change date filter to 2017F, can I get the reference line to take on updated data as well?

      The data points I would like to use for the reference line would be a calculated field (5YF UO Rental Growth) but filtered by State (DIM) and Year (DIM) (to USA and relevant year).

       

      Any help or suggestions will be greatly appreciated!

      Workbook attached. Thanks!