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

Dashcard filters seem to evaluate due date using incorrect time zone

Edited

Summary

I have a problem with a dashcard that should be filtering the cards for which it's aggregating statistics to include all cards due "today." Cards due at or after 9:00 PM, however, are excluded from the search.

Have I found a bug? Am I misunderstanding a feature? Or am I just confused?

 


The details

I have a board on which I've set up dashcards that filter for cards due today, sum over a custom field (completion time estimate), and display the total of all time estimates for cards with a due date of today. In theory, this should mean that I can see the total amount of time tasks due today are expected to take.

Here's the dashcard's filter configuration:

image_01 -- example dashcard filter 2022-12-31.png

And a screenshot of the aggregation configuration:

image_02 -- example dashcard metric calculation 2022-12-31.png

 

When I have a card with a due date at 8:59 PM, it's included in the aggregate total.

image_03 -- first example of aggregate total 2022-12-30.png

 

But when I change that card's due date to 9:00 PM, the aggregate total shown in the dashcard is decreased by the value of the custom field over which I'm aggregating:

image_04 -- second example of aggregate total 2022-12-30.png

 


Hypothesis: maybe this is a time zone problem?

I thought that maybe this is an issue with time zone settings. But when I go to check the Atlassian account time zone settings, everything seems to be in order:

image_05 -- Atlassian time zone settings 2022-12-31.png

 

I traveled recently, and I made sure to update my Butler account's time zone settings away from, then back to Pacific Time after I traveled, hitting the "Set Butler time zone..." button:

image_06 -- Butler time zone adjustment 2022-12-30 -- redacted.png

 

And I checked the computer's settings as well, just for good measure. Windows says the same as the rest of my settings:

image_07 -- laptop time zone settings 2022-12-31.png

 


So where next?

I'm stumped. I've got what seems like a simple "due today" filter, and it's not quite working for me. It's filtering in Trello cards for which the due date is yesterday with a time of 9:00 PM or afterward and it's filtering out Trello cards for which the due date is today with a time of 9:00 PM or afterward.

Any ideas? Have I found a bug? Am I misunderstanding a feature? Or am I just confused?

(N.B. I have also raised this as a support ticket, TRELLO-141572.)

1 answer

0 votes
Sal
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Jan 02, 2023

@Anonymous Aardvark,

Welcome to the community!

As I noticed, you've already raised a ticket with us reporting this behavior with the Power-Up Dashcards.

And also, one of my colleagues is already helping you with your question. So I recommend you continue with them so that they can help you with your case. Thanks!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events