
1. Re: Reference Line with Calculated Field, Filtered by Dimension on Scatter Plot
Yuriy Fal Jan 8, 2017 2:22 PM (in response to Jingwei Teng)Hi Jingwei,
Why not just use the [5YF Avg UO Rental Growth] 
the Average of 5YF Averages  as a RefLine?
Do the numbers of 3.5% for 2016F or 3.6% for 2017F look good for you?
If not, what the expected values would be, and more important,
what the underlying calculation / filtering logic would be?
Yours,
Yuri

2. Re: Reference Line with Calculated Field, Filtered by Dimension on Scatter Plot
Jingwei Teng Jan 9, 2017 8:41 AM (in response to Yuriy Fal)Hi Yuriy, thank you for your reply.
I would like to use weighted average (rental growth * no. of beds in each market) which is precalculated under 'USA' in my data. If I use Average of 5Y averages, I get a simple average (3.48% and 3.65% for 2016F and 2017F). But yes that would change with years automatically. Is there maybe a hack to set up a parameter with an equation? Or set up a reference line with filters/equation?
Expected value for 2016F Rental Growth Ref Line: 3.43% i.e. USA, filtered to 2016F
Expected value for 2017F Rental Growth Ref Line: 3.64% i.e. USA, filtered to 2017F
The difference isn't big here because of a largely homogenous sample. But I can imagine scenarios where weighted average and simple average yield significantly different results.
Thanks!

3. Re: Reference Line with Calculated Field, Filtered by Dimension on Scatter Plot
Yuriy Fal Jan 9, 2017 12:46 PM (in response to Jingwei Teng)2 of 2 people found this helpfulHi Jingwei,
Since I couldn't reconstruct the [UO Rental Growth]
USA values from the States figures, I just pushed
the USA values (already in the dataset) to each State
(using FIXED & EXCLUDE LOD combo).
Please find the attached.
Hope it would be of help.
Yours,
Yuri

4. Re: Reference Line with Calculated Field, Filtered by Dimension on Scatter Plot
Jingwei Teng Jan 9, 2017 1:59 PM (in response to Yuriy Fal)Thank you Yuriy! This works perfectly for Rental Growth!
I duplicated your FIXED & EXCLUDE LOD for Occupany Change but can't figure out why I'm not getting the expected results as in 'UO Occ' tab? I seem to be pulling up Avg Occ Chg of one year only despite doing Window_sum for 5Y?
Please see attached.
Your help in troubleshooting is much appreciated.

5. Re: Reference Line with Calculated Field, Filtered by Dimension on Scatter Plot
Yuriy Fal Jan 9, 2017 2:21 PM (in response to Jingwei Teng)1 of 1 people found this helpfulHi Jingwei,
What are the expected results for 2016F and 2017F?
If they're like 0.06% and +0.07% respectively, then you'd like
to set the [YF : Weighted OC] Table Calc Pill on Details
to be Addressing along (Compute using =>) [Year] 
just the same as for the [YF : Weighted RG] table calc pill.
Hope it could help.
Yours,
Yuri

6. Re: Reference Line with Calculated Field, Filtered by Dimension on Scatter Plot
Jingwei Teng Jan 9, 2017 2:29 PM (in response to Yuriy Fal)Thank you, Yuri! This solved the issue!! And I learnt something new

7. Re: Reference Line with Calculated Field, Filtered by Dimension on Scatter Plot
Yuriy Fal Jan 9, 2017 2:37 PM (in response to Jingwei Teng)Jingwei, you're welcome.