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

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


1 badge earned


Participate in fun challenges

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


Gift kudos to your peers

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


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!


Using rich filters to produce matrices of data

In a quest to migrate from static spreadsheets to dynamic dashboards, I've been seeing how far I can push the Qotilabs Rich Filters Plugin. I have a specific issuetype that uses a series of subtasks assigned to different individuals that need to be completed in a specific sequence. We use Google Sheets to alternatively display Status, Assignee, and Due Date per subtask, arranged in an easy to reference matrix.

I've got the first view I need working, the status view, with Smart Filter columns using the issueFunction in parentsOf() scriptrunner line, and three colour coded labels to return To Do/In Progress/Done statuses. This produces a matrix with my ~30 parent issues in a list in the Y axis, and the 9 subtasks per parent, each in their own column, in the X axis. The end result looks like this (issuekeys and column headings cropped out):

Screenshot 2022-03-25 170013.jpg

I'd like to use the Views functionality for Rich Filters to also have an Assignee view and a Due Date view arranged in the same way, but with this basic setup I would need to use Smart Filter labels to display hard-coded assignees and dates. This is obviously not an ideal solution, since assignees and dates might change, and since my stock list for each exceeds the 10 label maximum.

What I effectively need is to be able to populate the smart filter label field with a variable, i.e., issueFunction in parentsOf() will return one ticket per parent and subtask column, and if I could display the actual value of the assignee or due date of that ticket in the label space, that would be ideal. However, it seems that functionality doesn't exist, so I need some other way to return the values for these issue fields in a matrix like this. Maybe that's a different rich filtering gadget, or another plugin, but I'm stuck. Any thoughts?

0 answers

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events