It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to exclude unwanted Labels displayed in Dashboard Column for Story?

For Example: In Story there are 3 different Labels=ABC,Labels=XYZ and Labels=MNP. creating JQL Filter Project=Project AND Labels=ABC, In Dashboard it should display only Lables=ABC, but it displays 2 additional Column with Labels=XYZ, Labels=MNP

2 answers

1 vote
Nic Brough Community Leader Apr 04, 2016

It displays the labels there because they exist and you've configured the dashboard gadget to show you labels.

I'm not sure what you're trying to do here, but could you start with explaining "dashboard column" (what gadget?  or what report? etc) and then what you'd like to see from it.

JQL: project in ("EMI - Catalog", "EMI - Product and Item", "EMI - Load/Sync", "EMI - Brand Management") AND labels=Team_Hermes AND Sprint in (openSprints()) AND issuetype in (Story, "Support Ticket") AND cf[10211] != Spike

Gadget: Two Dimensional Filter Statistics
XAxis: Status
YAxis: Labels

Above JQL does not pull only Team_Hermes, if there are more than one Label for that Story, it pulls all the Label and shows in Dashboard as extra Rows.

Nic Brough Community Leader Apr 04, 2016

Ok, yes, that's correct.  It's showing you the labels on the issues you have selected.

Hi Nic,

Can you please let me know how we can avoid other Labels.

Nic Brough Community Leader Apr 05, 2016

You don't.  They're data on the issues you are reporting on.  So when you display the labels field, you get to see the values in the field.

@Nic Brough

I also would like some gadgets like this.

For example I want to display the issues with a label matching "Loc_*" and in the gadget (either pie-chart or table) only display these matching labels.

(Here the use-case would be I want some location based reporting with labels like Loc_Paris, Loc_Berlin ....)

Anyway to achieve this? Maybe have to go to a custom Confluence Report?

Many thanks

Like # people like this
Nic Brough Community Leader Oct 12, 2017

It's the same answer - your report says "show me the labels", so it shows the labels on the issues that match "label = loc_*"

I know the current gadget are working "as specified". But still you are not answering to my need.: how to do get what I am requesting. (Same answer does not help)

I have the same question. All the issues to be displayed have two labels, The first indicates the group owning the issue eg Engineering, QA etc and one indicating the functional area where the issue has been reported eg Video, Audio etc. I want to show the functional area only on a pie chart and hide the group information.

Like # people like this

We have the same question. For our project, we use different types of labels. We would like to display subsets of these labels (either specified by the names of the labels or by regex) in a pie chart on the dashboard. How can we do that? If it is currently impossible, can this functionality please be added? (The above replies do not answer this question.)

Like # people like this

I face the same question too. It looks messy when I try to create dashboard and it actually list out all the labels including the ones I don't wish to see (although it's labeled to the issue)


Hope to have this function and it would help a lot!

Like # people like this

Same here, I have the same need for this type of gadget.  I have labels for customer type and labels for function.  If I want to see the issues by customer type and I use the 2 Dimensional Filter Statistics, I have to scroll past all the other labels that I don't want to see in this context.

What I don't understand is how pie charts keyed to the label field decide which label to display for an issue with multiple labels.

For instance, I have 2 issues. One has a single label "A" and the other has "B" and "C".

Will the pie chart be split in half, with two issues illustrated? One side is "A" and the other side is... "B" or "C"?

Or will the pie chart be split into thirds, with a slice for "A", "B", and "C"? What will the Total Issue count be?

Nic Brough Community Leader Feb 10, 2018

It's a third - you've got three labels to display counts for.

This link helped me

You have to create a macro using that code, then use that macro in the entries of a table, and use the macro "create chart from table"

Hi there! Any update on how to exclude labels in a 2-dimensional Jira gadet? Any script or query that I could use to manipulate the output of my filters in Jira? Thanks!

Like # people like this

Hi, This is also a problem for me. Sames as people above I want to find a effective way to just see certain label stats, not all 'Labels', can Atlassian help make a filter for just 'Label =xxx'  and then if that filter created hide others labels attached to those issues in a widget? 

Like # people like this
Ananth K I'm New Here Jun 06, 2019

I have same issue. JQL filters labels you want , however the issues may have other labels too.  I want to see all these issues on my dashboard but want to display grouped by only labels of my interest and not other labels.  This is definitely very useful use case for Atalssian to address.

However, if community here knows way to do it , it would be great ! 

X or Y axis on the two dimensional dashboard to show the values that field has and you cannot control on what should be shown there, there is no provision to achieve what you are looking for. This is applicable not only to the labels, but to any other fields. If the field has multiple values and you want to show that in either X or Y axis, it will display all available values.

It is not a problem to solve, at least till now :)

Steve Dix I'm New Here Aug 16, 2019

Is there a gadget that allows me to apply a filter to the results that show in the dashboard.   I too would like to hide certain labels.   I understand that If I have 5 issues with lablel "A" and 5 issue that include both label "A" and "C", that today I will get a dashboard with 10 "A" results and 5 "C" results.  What I want to do is hide those "C" results on my dashboard counts.   Similar to hiding in many spreadsheet table features.


Is there a gadget that allows for this?

Nic Brough Community Leader Aug 16, 2019

I have not found one yet.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

1,087 views 7 0
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you