It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Showing the percentual of all boards and export to excel to creat KPI

Hello, I'm using Trello to organize my projects (53 total), but i need some help to see the "big picture" of all of them.

To explain better my idea, I dont wanna to enter board to board ( to see the status of each one). I wanna click, in the first page "boards" or "Boards of team", and somehow show's the status of all of them. (I dont know how, and dont know if its possible).

For example, one board, has 2 cards to do it, 1 doing it and 3 Done (3/6% = 50% Done). After a one day of work, we change the status(1 card to do it, 1 doing and 4 Done) - The new percentual will be 66%). But this values will be showed at "boards" to all projects (of course, each one with your percentual).

If its possible to do that, we can do it exporting to excel?
Doing this, I can see the whole status of all projects at week, creating a KPI and maneging better the projects the "we" forgot to work.

Thanks for the help, and sorry about my English.

 

trello.JPG

 

 

 

 

 

1 answer

0 votes
Iain Dooley Community Leader Apr 16, 2019

@Ricardo This is a good primer on exporting Trello data to Google Sheets:

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

But you can also represent this in Trello by creating a "board of boards" which is my go-to approach for project management. So you have a board with one card per project, with lists representing high level project state and meta information about the project stored on each card, then each of those cards is linked to a project board:

https://blog.trello.com/related-cards-related-boards

Once you do this, you can automate some reporting. It looks like you can't use the Butler Power up to loop through all cards in a board, but here is a Trellinator command that will loop through all cards in the board, count the number of cards in To Do/Doing/Done and set those values as custom fields on the front of the cards once per hour:

https://gist.github.com/iaindooley/6f85790c31667d77ae4aacd47773d7dd

You could do other things like measure card times in list and add a "Blocked" label to any card linked to a board where a card has been in the "Doing" list for more than 7 days, for example.

The "board of boards" setup is actually the example I give in my introduction/howto on setting up Trellinator:

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,568 views 13 5
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you