Hi,
In my report I have a few measures which track values such as "number of items in queue today" which essentially track the number of rows in a table with a due date of "<today", "today", "tomorrow", "next 2 weeks", "other".
The data in the table is constantly changing as things are added and removed from the queue and there is no "historic data" table.
I would like to create a new table which logs:
- Date and Time of Refresh
- Value of each of the measures at the point of refresh
The data refreshes frequently throughout the day. I would only be using the values from the earliest refresh on Monday morning - so if there's a way to only capture this data on the first refresh on Monday morning then that would be useful, but if this is difficult I understand how to filter data and would be able to pull the data I need if it were to track values at every refresh.
So I would be creating a log of the values of the measures as the weeks go on. This would then allow me to create a graph to show any patterns between the value of the measures on every Monday morning.
Please let me know if you need any further information?
Thank you in advance
