Hi team,
I am working on building a dashboard for my team and within it, I would like to have two pie charts that show time logged on tickets per client.
See an example image below for a workload pie that shows work logged for the past two weeks:
This pie charts works just fine, because I am only looking at hours logged in the previous weeks.
Now the issue I am having is with the 'current week' pie chart.
The issue is that if I have a ticket that I have logged time on it in the previous week, it will show up on the current week pie chart as well, when I log time on it in the current week.
On the image below, you can see it is showing 8h 31m logged, but only 2 of these are from the current week. The other 6.5h are hours logged in the previous week.
So my question is, is there a way in which I can setup a workload pie to show hours/work logged only for the current week. (even when tickets have hours logged on them from a previous week)