Active List time limited
I am trying to run a weekly report from an active list, however if the list has the same key fields the creation time is keeping the events in the lists for longer than a week.
Is there a way I can rectify this problem with my limited knowledge of lists
Thank you in advance
In case your interested in displaying events from a specific time range you can your report query to run on a set time range such as now - 1 week
This will display only the last week's events and not the entire list
You can also set a TTL in the list to make sure that events older than 1 week get deleted
If you require more assistance please provide more details about your usecase
I have a similar issue where I cound the number of times an events occurs. The issue is I want to create a weekly report that only provides the number of counts for the week period. Because there is the Creation Date, it is including the counts older than a week...
Any help or ideas appreciated.