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!


How to filter by labels?

I am stuck again trying to add a filter based on labels. It must have sth. to do with the fact that Labels is an array data type. When trying to add a text based or dropdown based control I get empty preview table.

Screen Shot 2022-03-08 at 12.46.07.png

1 answer

1 accepted

0 votes
Answer accepted
Matthew Lempitsky
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Mar 08, 2022

When creating your {LABELS_DROPDOWN}, a good approach would be to ensure you're creating a dropdown with all of the potential labels.

To create a dropdown control of all the labels you can simply select the "Labels" column from the Jira Issue table and then use the "Explode" aggregation. You will then need a "Group & Aggregate" step to remove any duplicate labels:

You can then change your Control Settings so that you can select and filter on multiple labels:


However, there does appear to be an issue with the Empty state setting; if there are no labels selected, no results are returning, so a minimum of one label will need to be selected in the control.  

You can connect your newly created dropdown control to your chart using the same method you used in your screenshot:




This is quite helpful and as a matter of fact I have done all those steps but it did not solve the problem. Preview table still returns 0 rows. I think I managed to narrow down the issue to the fact that I am also using History table. For results where history is not involved adding filter based on exploded labels work.

So my entire Visual query looks like this (not working)

Screen Shot 2022-03-09 at 12.01.41.png


When I remove Jira Issue History to String = Closed, and Status = Closed it starts working. I need those fields as I want to operate on Closed tickets only for this data visualization.

Screen Shot 2022-03-09 at 12.29.12.png


EDIT: I am now thinking that I might need to implement additional query and join tables before doing filtering. Will update here if that resolves the case.

EDIT 2: Confirmed, I had to build the table from two queries with Inner Join and only then results could be properly filtered by labels.

Like # people like this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events