Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

×
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

finding max due date for issuleLinks in structure formula

I have added a column that displays all issues linked to the current row by a link "Tests" using this formula. It is successfully printing the URLs of the linked issues separated by comma. ( i sued "wiki markup" option in dialog box to print a clickable link)

WITH _format(issue) = """[${issue.key}|${issue.url}]""" : issueLinks.Filter($.type = 'Tests' AND $.destination = this) .MAP(_format($.source))

Now, I would like to add another column to calculate the max due date from among the links. I tried below formula but it only shows the date of the first element in the comma separated list, regardless of whether I use MAX or not. ( i used Date/Time option to get the due date display correctly)

Max{TestedBy.ProjectedFixDate}

How can I get the maximum of the due dates among the links?

1 answer

1 accepted

0 votes
Answer accepted

Actually, this is working, I did not have due date set correctly for the issue with latest date in the row that I was using to test.

Suggest an answer

Log in or Sign up to answer