I want an automated weekly table of open tickets for each field dropdown selection

Makai Baker
Contributor
June 25, 2024

I need help with an elegant solution for creating a table in which each value in the first row consists of a custom field's dropdown list and the second row consists of the amount of open tickets that full under each custom field's dropdown value. I also want it to be easy to add new dropdown values.

Screenshot 2024-06-25 140534.png

My first idea was to create a variable "SiteList" that contains each SiteScreenshot 2024-06-25 133849.pngthen a branch rule for each Site Screenshot 2024-06-25 133910.pngthat will lookup issues for each site Screenshot 2024-06-25 133926.pngand then a lookuptable would've stored each lookupissue Screenshot 2024-06-25 133941.pngsuch that i would be able to reference (the size of) each lookupissue 

I would like the table to be something like:Screenshot 2024-06-25 142204.png

 

but cannot use smart values in lookuptable name

2 answers

1 vote
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 25, 2024

Hello @Makai Baker 

Have you considered using a Dashboard instead, with a Two Dimensional gadget? The X axis could be your dropdown field and the Y axis could be Status. If you want to see only the issues that are In Progress, you can create a filter to select all the In Progress issues only, and base the gadget on the filter.

The gadget will automatically split out each of the values in the dropdown field.Screenshot 2024-06-25 at 2.38.44 PM.png

The output would not be sent to you in any automated way, though.

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 25, 2024

Hi @Makai Baker 

Lookup tables cannot be dynamically created as you tried.

And even if tables could, the advanced branching would not help as it would create a new table with each loop item, and then the table vanishes at the end.  (Branches which could be on more than one thing are executed in parallel and asynchronously, in separate processes.  And so the branch may not even finish before the next step after the branch in the rule starts.)

 

If you know the Site values when the rule is created / updated, you could use smart value, list filtering and the lookup table, entries function to iterate the values:

 

For example, create the lookup table for the current values, using the hardcoded site name as the key and in a filter to count the issues with a math expression:

  • action: lookup issues to gather the data
  • action: create lookup table, perhaps named tblSiteCounts
    • row
      • key: Site1
      • value:
{{#=}}0{{#lookupIssues}}{{#if(equals("fat site[dropdown]".value,"Site1"))}}+1{{/}}{{/}}{{/}}
  • repeating to add all rows for the sites...
  • action: some action
    • when you need to iterate over the values in table, use
{{#tblSiteCounts.entries}}
* {{key}}: {{value}}
{{/}}

To add / change sites later, just update the table keys and value filters.

Kind regards,
Bill

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events