Card age metrics for Trello

Hi there!

I am a user of a business class Trello and I need to see the following metrics for the board:

We have a process in Trello with several lists that are statuses of the process.

Let it be: Created - In progress - Verification - Done.

What I need is simply to see how many days a card stays in every single list.

I would like to find any report that will show me the evarage time for all cards, average time for cards with a particular label and possibility to see details for every card (as I have said - how many days he card stayed in every list)

I have found goodle chrome add-on to see true age of a card but I can't create a report to see the overall metrics for all cards on the board to measure the process. As we are trying to improve some of our metrics it is crutial for me to measure it somehow to see if the approach we have created works or not and what are our week points.

 

Harvest does not work as it count the time spend per card but not the time the card was on every list.

Screenful doesn't seemt o help as well.

 

Do you have any other ideas? It would be really appreciated.

Thank you for support.

Kind regards,

Olga

1 answer

1 accepted

Hi Olga,

 

There are a couple of other tools that we typically recommend for reporting, so you may want to check these out:

Hopefully one of them will give you what you need!

Ultimately, the API may be your best bet, if you have any developer resources available to you. Because the API includes all data about a card, it's the best way to build advanced reporting in Trello. If you haven't checked it out already, I'd recommend checking out the 'Getting Started' section of our developer documentation site: https://developers.trello.com. It will walk you through using the API to access your data in Trello.

Once you have gone through that and understand how to use a key and token to access data in the API, you may find the following query as a good starting place. It includes almost all of the information about a board, including pluginData: https://api.trello.com/1/boards/[boardId]?fields=all&cards=all&card_fields=all&pluginData=true&card_pluginData=true. You'd just need to replace [boardId] with the ID of your board.

Hi Michael,

Thank you for detailed answer. I will definetely take a look on API possibilities!

However I have hoped that a simplier solution already exists. It is a kind you ask how to warm up a soup but get an answer how to plant vegetables and grow a chicken to prepare the soup from the beginning :))) I am only joking!

 

Kind regards,

Olga

FWIW, I have almost exactly the same need. I, too, am a business class user. 

If someone has a simple (non-technical api-related turn key solution), please ping me! 

Coach

Dan

007

At

Gmail

Hi there, I ended up using www.reportsfortrello.com. It doesn't allow to have all the data I need at once, however you can run several reports and combine all the data in Excel to see the whole picture. Unfortunately it is the best option I have found so far.

Regards, Olga

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Apr 23, 2018 in Trello

Using Trello to manage events

As a Jira power user, I was at first doubtful that Trello could benefit my workflow. Jira already uses boards (ones you can customize!), so why would I even need to use Trello?! In this post you will...

798 views 10 11
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you