How ca I see basic stats in Trello?

Greg Wallace September 14, 2020

I’m just wanting to see how many new cards are being added to a board in a particular timeframe. We use a board for tacking leads and I’m keen t know how many are added each week as a metric to tracking marketing progress. 

I’ve tried a few power ups but with no success. 

Any ideas?

1 answer

0 votes
milynnus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 15, 2020

@Greg Wallace the ability to count can be achieved in many ways especially if you can use Trello API like using the fetch_actions function. By setting the filter to look for createCard and since (datetime object)...and also keeping track of last processing date ...etc etc

def fetch_actions(self, action_filter, action_limit=50, before=None, since=None):

Alternatively, with some creative use of labels and resetting thereafter, you can create simple report variables every Sunday 2am and feed this via a HTTP Request to an endpoint that can count for you or send it somewhere.

Here's an example of how this is being used to update a CF on the card but a simple count would be just len([list of {cardidlong}]) and returning it via a httprespose.thisweekcount  https://youtu.be/gr5_tWnO-Xw learn more here 

Or keeping them on a particular list and just count and keep it, use Trello report to send data to you via email....etc etc.

My question how would you want to keep this piece of data. Will it be part of a bigger but simple dashboard like https://youtu.be/YiuyeeSyhgg or simply record it somewhere?

milynnus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 15, 2020

Here's a short video of one solution using the report variable.

https://youtu.be/X2lbENPf0ow 

Here, I am using card with yellow labels to denote cards created this week. It can be other mechanisms so long you can get a report variable around them and able to reset them after the run...which may be a new challenge. Nothing prevents you from adding to the module to remove the labels or the reset needed.

every day at 5:45 pm, create a report in variable "repo_var" with all cards with the yellow label using pattern "{cardidlong}", post to url "https://25368.wayscript.io/butler/?registry=5f216a81........&module=5f608738b........5704" with payload "{\"report_variable\" : \"{$repo_var}\"}", and create a new card with title "New Card Count for {date} is {httpresponse.count}" in list "Next Step"

 

milynnus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 15, 2020

@Greg Wallace The http request can also be a call to the fetch_actions. Here is a working code but not added to my Butler Add-on

from datetime import datetime
para = {
"board_id": "5f196.......4266c6de", # use module to get idModel using Board as the scope and a board name
"isodate" : "06-09-2020",
"time24" : "12:34"
}
sp_variables = ""

date_str = "{} {}:00".format(para['isodate'], para['time24'])

format = "%d-%m-%Y %H:%M:%S"

datetime_obj = datetime.strptime(date_str,format)

board = client.get_board(para['board_id'])
actions = board.fetch_actions(action_filter='createCard', action_limit=50, before=None, since=datetime_obj)

sp_variables = json.dumps({"count" : str(len(actions)) })

Above can be used to count anything by making the filter as input from Butler. This is probably overly simplistic assumption on what constitute a new marketing activity for you since no other criteria were applied. 

Frankly, I would not be too surprised should someone come up with a ingenious solution. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events