Two Dimensional Filter gadget shows "Irrelevant" column
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
When configuring a two dimensional filter statistics gadget and selecting a custom field in the "XAxis" (say owner), the resulting two dimensional filter shows a column "Irrelevant" although the field has values for the custom field.
As it can be seen below, the owner field has a value:
Environment
Jira Software Server / Data Center 8.0.0 and any higher version.
Diagnosis
Go to Issues → Custom Fields and search if there are duplicate fields i.e custom fields using the same name for the field chosen for XAxis.
Cause
Unintended custom field was selected while choosing the XAxis in the drop down. If there are duplicate custom fields with the same name as the one picked up for "XAxis" or with the name duplicating those of a standard Jira field, the incorrect one was selected. For example, there might be another custom field with the name "owner", and this is what is getting picked in the Two Dimensional Filter configuration instead of the intended one. Generally, "Irrelevant" category in statistics widget appear automatically if issues in the configured filter do not have any data for the statistics type selected.
Solution
Modify the Gadget's configuration and select another entry with the same name for XAxis.
Click the three dots menu>Configure
Change the X and/or Y Axis and select the other field with the same name.
For example, initially, if the highlighted owner was selected in the drop-down, change it to the other one.
After changing, you should see the expected results in the gadget.
Was this helpful?