How to get number totals for filtered columns

Question

Hi,  One of my clients asked recently if it is possible to show totals for filtered columns.

They are using a Trello KANBAN with hundreds  of cards and in "Sync" meetings they apply various filters.

Grateful if anyone can advise how to see the totals for each filtered column.

Many thanks,

Peter C.

Alex Koxaras -Relational- · Accepted Answer

Hi @Peter Cranston

If you use the filter, you can have the number already underneath each column:

Do you mean something else?

Silvia · Accepted Answer

Hi @Peter Cranston ,

I saw you have a similar question posted so I thought I could jump in with a suggestion.

Have you looked at Blue Cat Reports? We specialize in filtering busy boards, counts, averages, bar charts, historical lines and other analytical or operational goodies.

Here is an example of a report with the filtered number of cards based on specific lists that you can select.

When you sign up for a trial with us at Blue Cat, you can reach out to our support through the app and we are happy to help with creating a report as the above or anything else you might need.

Tommi Partanen · Accepted Answer

I've been struggling with this same issue @Peter Cranston because I need to monitor team members' workload and that people are not adding cards into the process by themselves.

The only workaround I've found is to create a board button that creates a report and emails it to me. You can't get the total number of cards on the report itself, BUT the run log of Trello gives out the total number of cards added to the report. :D

Example from the log:
"Created a report with 35 cards on variable {$myreportvariable}"

Tommi Partanen · Accepted Answer

Update to my previous hack:
You can also get the number of cards to the email report by using numbered list formatting when listing the tasks on a report.

Example:
1. [{cardname}]({cardlink})