Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

How to run reports

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?

4 answers

0 votes
Iain Dooley Community Leader Oct 06, 2020

@Nick Traynor have you looked at the BlueCat reports powerup to see if it has what you need?

I had a look at the bluecat reports, but cant get past their pricing and signup screen, which on software turns me straight off ... if they cant tell me on the homepage or within one click, I'm not signing up to see what it does, however good I hope it might be.

Run a list ... when you make the first card of the week, if you are using the chrome extension Pro4Trello, it gives all cards a number, probably from the trello database ... just use maths ... saves you $4/mo too.

@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. 

@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("\n")
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

 

0 votes
Antonio Panea Community Leader Oct 07, 2020

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

Suggest an answer

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

📹 What is Trello?

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. I'll be sharing with you a series of videos with my top tips on how to best use Trello...

807 views 13 30
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