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,459,111
Community Members
 
Community Events
176
Community Groups

How can I see how long it takes for lists to turn over?

I am looking for a way to see how long it takes for cards to make their way though the workflow, but I don't want to track the individual card, I want to see how long it takes for a list to completely turn over.  So more focused on the List and not the Cards.

1 answer

@Thomas Pierson 

You can use a combination of 

when list  has (exactly/more than/fewer than) x cards and capture the {date~X} in 2 CFs  and compute the difference to get the list turnover. Try it.

I'll try, but will that work if there are cards being added to and moved out of the lists daily?  For instance, there will always be say 10 cards in the list, but I need to know how long on average a card is staying in the list.

@milynnus I can clarify more clearly what I'm after... I wish to see how many cards are entering a list and moving out of a list in detail or on average over a given period of time (daily, weekly, etc).

milynnus Rising Star Mar 18, 2022

@Thomas Pierson 

From your clarifications, there are 2 requirements (1) time on list for a card (2) movement in/out of a list. 

The short answer is that both can be achieved but not without code since you are looking at stats for different periods. 

Try Blue Cat power up to see if you requirements can be achieved. Otherwise some custom code will be required. The movement data is captured on every card. There are also webhook so that the data can be captured external for reporting. 

@Thomas Pierson 

I took opportunity to learn how to use Streamlit with Deta Base. Below makes use of a webhook with list_id as the idModel to track the movement of cards in and out of the list.

To build a custom dashboard will take a bit longer. As you can see, I needed a date which can be used to generate different periods.

It is dynamic because the data will be update when you refresh the browser.

Screen Shot 2022-03-19 at 6.04.20 PM.jpg

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events