I have a dashboard, on which I want to show a list of tasks (from a task list) that have been marked with the status Complete during the current week. Is there a way to do this with the Content Query Web Part? If not, is there another way?
Yes you can use CQWP to show the completed tasks through last week by filtering the following:
- The [Task Status] column equal to
Once the task set to completed, the
[Modified Date]will be changed to the current date, so you can filter the updated tasks within last week as the following
The [Modified Date] Greater Than or Equal to [Today]-7
The final filter setting in CQWP should be like this
The output should look like