How to find out the number of projects an assignee has worked on for a given month

1

I’m using Asana for project management and I have imported the tasks from Asana projects on to the Coda Doc using packs, with the help of this data i would like to know the number of projects an assignee was invloved in for a given month.

https://coda.io/d/_dougboif-4A/Number-of-projects-alloted-to-assignees_su8Aw" is the link to the Doc.

Thanks in advance.

2

Hi @VINAY_B_C,

I have amended your doc.

If you look at the Number of projects alloted to assignees page the table has two new columns.

They both do the same thing however one ends in .Count() to return the count.

I have used .Year() and .Month() as matching creteria so you don’t have to mess around saying that a date is great than or equal to StartOfMonth and greater than or equal to EndOfMonth.

There may be a more effecient way of doing this however I can’t see one.

I am also only going by Start On as the matching date however you can use a different date field or even multipe date fields if you expand the filter to include an OR statement.

Hopefully this is what you were looking for. If you need any further help refining this please let me know.

All the best

Dale

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.