Hello,
Anyone knows if it is possible to count open tasks up to a specific Due Date. I tested some scripts but they just count the open/closed tasks on a page.
Regards,
João
Hello João,
Yes it is possible. You'll need to use combination of Table Filter and Pivot Table macros to achieve the goal (Table Filter and Charts add-on).
The structure should be Pivot Table -> Table Filter -> Task Report.
Table Filter: add Date Filter for the due date column and set a specific date or date range. You'll get a filtered table with actual data.
Pivot Table: select Description field in Row Labels field.
So you can get something like this:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.