Hello, I have data on about 100 companies that is fed by a SharePoint list that has versions turned on. Over time, the SharePoint list is updated with new information. For example, as the number of employees changes, it gets updated. What I'd like to do is add a date slicer so a user can slide it back and time and the table showing statistics for those businesses would change to reflect what the data was on that past date. So ABC Company has 1,210 employees as of 9/28, and on 9/10 the employee count was changed from 1,288 to 1,210. I'd like to be able to slide the date slicer to the left and, for example, this record for ABC Company on the table would show1,210 employees until I slide back to 9/10 and before where it would then be 1,288. Basically getting a snapshot of all the data in the chart and view how it changes over time when you slide the date slider back.
I tied the modified filed to a calendar, but the slider is just filtering by all modified dates for any of the 100 company records. Then I tried adding the version records to the slicer and that just added a sublevel to select different version numbers. I'd like all 100 companies to continue to show on the table regardless of where the date slicer is moved to, but just have data change for each record as appropriate to show updates that were made over time.
Any help would be greatly appreciated!! Eric
I tied the modified filed to a calendar, but the slider is just filtering by all modified dates for any of the 100 company records. Then I tried adding the version records to the slicer and that just added a sublevel to select different version numbers. I'd like all 100 companies to continue to show on the table regardless of where the date slicer is moved to, but just have data change for each record as appropriate to show updates that were made over time.
Any help would be greatly appreciated!! Eric
