I am looking to have a basic Line graph by continuous date (in weekly format) vs revenue but I want to put the YOY Revenue Value in the tooltip. So for the week ending Saturday 9/8/2018, it would display the normal weekly aggregate for 9/2/2018 - 9/8/2018 on the line graph but I want to have the value for the aggregate Revenue from 9/3/2017 - 9/9/2017 as that is the corresponding date range from 2018 off by one day. I am not sure how to do this with LODs because it gets tricky with the dates being off by one. Does anyone have any experience with this or ideas?
Once again, I am able to answer my own question with further research on the forums.
For anyone encountering the same problem, the answer is a simple table lookup. In this case, YOY calculation for revenue on a weekly period to put in the tool tip would be accomplished by Lookup([Revenue], -52).