Did you figure out a solution for this? I am not quite following with the calculation that you are doing to get the reference line for the current month but if it's based on last month values and the data in the view is filtered to only include the current month, then this will be challenging. One thougth would be to create a secondary data source that contains the aggregate values for the reference lines from the previous month and have them associated with a current month date for data blending (or in Tab 10 - to a cross table join perhaps) .
Thanks for the message Patrick, it is challenging as I want to see this month’s records with a reference line (goal) which is calculated on last month’s performance.
Currently we have made no progress, however placed it on a lower priority shelf for right now.
Support & Services Data Analyst
(W) 512 906 3075 | (C) 512 507 1470
Twitter<https://twitter.com/lifesizehd> | Facebook<https://www.facebook.com/lifesizehd> | LinkedIn<http://www.linkedin.com/company/lifesize-communications> | Google+<https://plus.google.com/b/107083103726480679881/107083103726480679881/posts> | YouTube<http://www.youtube.com/user/LifeSizeHD> | Blog<http://www.lifesize.com/videoconferencingspot.com>