How to run reports

Question

Trying to figure out how to run a report to see how many new cards are added per day/week/month etc. per board. especially helpful if i can generate a list of cards added on a specific day, time range?

Antonio Panea · Answer

Hi @Nick Traynor ,

you can give a try to Crmble Power-Up. It gives some Dashboard graphics that could be useful for you maybe.

Cheers

Toni

milynnus · Answer

@Nick Traynor

Create this

every day at 5:00 am, create a report in variable "card_age" with all cards with custom field "Basecamp" set using pattern "[{cardname}]({cardlink})^{cardcreationdate}^{cardagedays}", and post to url "https://25368.wayscript.io/test?registry=None&module=None" with payload "{"report_variable" : "{$card_age}"}"

the end point basically split the report variable into fields

item_list = para['report_variable'].split("
")
item_list.pop() #remove last element

sp_list = []
for item in item_list:
split_item = item.split("^")
sp_list.append(split_item)

and there is a script that update a google sheet (just one way to show the data)

CardCreated OnAge in Days[Create card from unchecked checklist items and move to a list](https://trello.com/c/59XDybpj)July 16, 202083.35[Create card from unchecked checklist items, append link and move card to list](https://trello.com/c/NRdHKMcO)July 16, 202083.31[List unassigned member in board](https://trello.com/c/z0naiXMv)July 30, 202068.52

milynnus · Answer

@Nick Traynor

Trello variables has the following info:

* {cardcreationdate} the date the card was created.
* {cardagedays} the age of a card in days, with two decimals (e.g. 1d 6h => 1.25).
* {cardagehours} the age of a card in hours, with two decimals (e.g. 1h 40m => 1.67).
* {cardageminutes} the age of a card in minutes, with two decimals (e.g. 1h 40m 30s => 100.5).

In my post "A Powerful Combination"

I illustrated how you can use the report variable with a http request to an end-point to do more processing on the data. You can use a pattern [{cardname}]({cardlink}) and {cardcreationdate} and send this to a spreadsheet or provide additional start/end date and time and have the end-point return some output to you like an email.

It helps if you have the capabilities to support the endpoint including programs to implement your specific requirements.