Tricky one for the group here.
I want to answer the following question:
I've included a simple sample dataset in excel with the following:
1. a simple account table
2, a simple activity table
3. a viz on the merged data tab that shows the ideal output, a table listing the accounts with calculated fields on number of tasks based on filtering for account owner (which automatically filters task owner), Type of task (multi select preferred) and time