How to remove "None" Column/Row appears after using Smart Filters for Rich Two D Table

[rajnish2494]

Hello All,

When we use Smart Filters in Rich Two D Table, there is additional Column/Row as "None". How can we remove this Column/Row. This cause issues when you want to see some sorted data. Value with "None" column impact the Total value.

[Vishwas]

Hey @rajnish2494 

None option means gadget is trying to show for the dimension you had selected doesn't have any value selected for those tickets. Ideally it will come up there as it has to show the tickets for the query you have configured where value is empty.

It's like i have Product as custom field with A,B,C as values for the field. Now let's say we have 100 tickets in the project and only 50 of them have value set for product A,B or C. Rest 50 have empty for the field Product. So when we try to show the data in gadget it should shoe 100 tickets as per the filter setup rite, hence it shows as None for tickets which doesn't have any value.

Suggestion here would be to write a JQL filter for your smart dashboard to only include the values that you want to show. For example considering above scenario I explained JQL could be Product in (A,B,C) or Product is not empty this makes sure that None value are not shown.

Hope this helps !