Remove a specific row from a table

[emagnun]

I have a used "Jira" macro to get the number of tasks for each team member. Below is the result of the macro. 

Now, using this table as an input to "chart from table" macro, I'm trying to show a bar graph for each assignee. But it also prints "Total Unique Issues" as assignee. How do I filter out this row?

I don't want "Total Unique Issues" in my chart, can I use table filter to remove this from my table before using it for Chart? Or will it need table transformer macro? Or any other suggestions? Thanks for your help in advance.

Update: 
======
I found a way using "table filter" to remove it. I just did a reverse filter for "Total Unique" and I could get it solved. Still I would like to hear more from experts, if any other methods.

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @emagnun ,

You've found the right solution with the Table Filter macro and its reversed filters. Hope that it didn't take long and you weren't stuck with the case.

What concerns the Table Transformer macro, it comes in handy when you need to display only several columns (not rows!) from a big table. So, you list the required columns in the custom SQL query and the macro will return only them.

For example, SELECT T1.'Assignee' FROM T*:

And if you need to hide several columns, then it is easier to use the Hide columns option within the Table Filter macro.

[Tinker Fadoua]

@emagnun 

Did you try to create a filter (JQL) in Jira With the team members only? then import the macro to Confluence page and try the exact steps you did then see if you will get the graph you want.

Best,

Fadoua

[emagnun]

@Tinker Fadoua Thanks for the feedback. 

The problem is that "Jira" macro adds this "total unique issues" thingy to the JQL query. So, if I am using this "Jira" macro, i need to filter it out explicitly. 

Btw, I was able to filter out by using a "Table Filter" macro (added reverse filter for "total unique") and now my graph is alright.

Still curious if there are other ways.