Statistic from Archived cards

[Turan Ismayilov]

We have a small department and add cards to archive daily( cards about who did what and else). Can I get a monthly statistic of that? of their activity.

Not from print and export->CSV and JSON because they are unusable for that.

If you know any tips related to this or any answer, I would appreciate it a lot :)

[Vongsawat · Accepted solution]

You could have a private Reports board with a card for each team member. With a numeric Custom Field for ArchivedThisMonth.

Then have a Butler Rule that triggers on when a card is archived by a certain member (or that has a certain member attached), Find that member's respective card on the Reports board (by url), and increase the number in the custom field ArchivedThisMonth by 1. Recreate the Rule for each member.

Then on the Report board, have a scheduled command that triggers monthly, sets the card description to "{carddescription}/n{monthname}: {{%ArchivedThisMonth}}", then sets the ArchivedThisMonth to 0.

Edit: after this is optional stuff

Technically you could also use the Report function for the last part instead? But I'm not as well versed with that.

You could probably collapse the first rule in to a single rule, but that requires naming the cards in Reports properly such that you can search them with {cardfirstmemberusername} or {username}, depending on how you set things up. One step at a time though.

You also might want to filter what you'll count as an archived card as well, which depends on your set-up, to hopefully reduce the false positives. Like someone creating a card, realizing they made a mistake, and archiving it to start again etc.