Report on Completed Tasks

[Rob Garcia]

I am looking for a way to automatically capture the number of tasks that are moved into the "done" column each week so I can provide a report to outside stakeholders. 

I do realize I can count them up each week but I am looking for an automated process using a power-up that I can dump into Google Data Studio. 

Let me know any suggestions. 

[Dean Rowntree]

I've been looking into this and I started using the VizyDrop Power-up. But then my company needed a bit more than that, so I use a Chrome Extension called TrelloExport and export an xls file. I then use Power Query in Excel to get exactly what I want.

The ultimate goal for me would be to use Power BI with a custom connection and have the data refresh in real time, probably like how you want it to work in Google Data Studio.

[Rob Garcia]

Thanks for the information. Quick question, when you do the Trello export are you able to see how many items are in the done column or is that a data point that you have to add?

[Dean Rowntree]

Yes, its quite customisable with plenty of options to get what you want to use.