I have a 1 month rolling average for a value that is calculated in AF using Value Retrieval Method. Management wants to see a "dashboard" in which we show the last 12 monthly averages. So for January, that would be the value of my 1 month rolling average tag at 2/1/17 12:00:00 AM. And then next to that would be my value for December (1/1/17 12:00:00 AM). Is there a way to force variables to show up at a specific time regardless of the overall timeline selected?
Or, I'm I going about this completely wrong?
Attached is the Excel Spreadsheet they'd like me to duplicate/automate in Coresight. Thanks.