How can I make reports from the tasks I have in Trello?

Marcela Arango Impact Hub

I would like to make reports about the tasks that I have in Trello, like for example:
- How long is each task on each board.
- Divide the information according to the labels
- Count how many tasks were moved from one board to another in a given period of time.

I've found some websites but none of them have the results I wrote above. Does anyone know other websites I could use?

Iain Dooley

@Marcela Arango Impact Hub this is something you'd need to do using the API. This is a good primer on using Google Sheets as a reporting tool:

http://www.littlebluemonkey.com/blog/automated-trello-reporting-using-google-spreadsheets

I actually created a framework based on that guy's work that makes it quick and easy to create Trello automations using Google Apps Script:

https://community.atlassian.com/t5/Marketplace-Apps-articles/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

Using that you could run a report every day for example and populate a spreadsheet with the data you're after.