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}

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.