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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,998
Community Members
 
Community Events
176
Community Groups

How to use specific items on cards to determine a weekly total of that information

We use trello for production and it has been wonderful. We use the calendar power up for deliveries as jobs are completed. Essentially our due date is more of a delivery date and we base production off of the deliveries for the upcoming week or two. To take things to the next level, we would like to take key pieces of information from the cards (job name, due date, and board footage) to somehow use it to see a board footage weekly running total that can help us visualize the future weeks, where we can add more jobs to production, or realize when we are too full based on our production limits. Any ideas how we can accomplish this? We currently have a spreadsheet that tracks the job name, due date, and board footage information.

4 answers

i am working with susan2 on this board, and we are trying to figure out the sum of a specific custom field for specific cards. ex  the sum of bdft(custom field) for cards with dew dates between sunday- sunday equal 12345????

@susan2 @Adam Perry 

Thank you for asking this question. The Dashcard is turning out to be really useful on my end.

One tip since it took me a few minutes to figure out...

If you want the Dashcard to display the numeric sum of your custom field (bdft/board footage) instead of the card count, you have to:

- Open the Dashcard

- Scroll down and select "Explore and Edit"

- Then go to the Metrics tab and select the numerics field.Screen Shot 2022-02-17 at 2.12.58 PM.png

Like Oscar Triscon likes this
0 votes

It sounds like a good use case for Dashcards: https://trello.com/power-ups/6048e897c73d032a983e2a7c/dashcards

Thanks, I will check that one out as well!

It doesn't appear that the Dashcards support custom fields. I'm not sure if that's an issue when it comes to pulling your board footage.

So many great ways to work with data in Trello though!

Dashcards supports computation of the sum, average, minimum and maximum on numeric custom fields.

I didn't realize custom fields was a filter. Will go check it out - would love to use the Dashcards.

Grateful to susan2 for bringing this topic up!

@Oscar Triscon I was confusing the Trello Dashboard with Dashcards, hence the confusion over custom fields. Dashcards are a great tool - have already found several applications including a sum originating with a custom field. Thanks again for the clarification.

Like Oscar Triscon likes this

Have you worked with the Screenful Dashboard power-up? I just started using it for a consulting project - the need on my end is to manipulate a few data points into a visual overview which sounds similar to what you want. Based on my tinkering so far, the power-up does seem able to pull from custom fields and other chosen data points to create different types of visualizations.

Thanks so much for replying, we will take a look at that! Have a great day!

@susan2 @Cynthia Brown the Blue Cat Reports power-up is also a good option for reporting on custom field data. Happy to give you a quick demo if you want to grab a time from my calendar https://calendly.com/robinwarren/30min :)

I should have mentioned that our job name is in the title on the card, and our board footage is a custom field.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events