Count open tasks on macro "Task Report" up to a specific due date

[João Andrade]

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

[Andrey Khaneev [StiltSoft]]

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: