When you create result manipulations, there might be parts of your query that need to be there to ensure the calculation is correct, but that you do not need to display. For example if you use a result path calculation to display the difference in results over time, the first reference result will be empty.
Empty columns or rows can be hidden using the hide part of your result result manipulation. If you are using a table visualization, you can hide columns when customizing (see Customizing tables).
To hide rows or columns
- In Query Builder, click the result manipulation icon (
). - Select Hide part of your result.
- Enter the number of first and last results you would like to hide. Alternatively, you can type in specific rows or columns.
- Click Apply
- Hide results will automatically be added to the Filters panel.
6 Comments
Is there a way to conditionally hide results? For instance, if a row does not contain any data, hide that row? I sometimes have agents who do not touch tickets for the past week and I don't want their name showing with empty data in a chart.
Thanks!
Hi Judd,
Can you explain in depth how you've built your report?
I would assume that you could add a filter and exclude all null values. :-)
I have a 1 x 3 table with 3 results displayed in the first row. When I hide the first 2 columns, the entire result disappears. What's going on here? I'd appreciate your help with this, but judging from your response time with the last two gentlemen, I probably won't hear back from you for two years...
Hi Eric, thanks for the question. I tried to replicate this here, but was unable to reproduce the error. If you're willing, would you be willing to post a before and after screenshot of what you're trying to accomplish? Alternatively, we can open a ticket to have someone work with you to look at this. Thanks!
Rob Stack, would you please create a ticket for me? Thank you.
Thank you, Rob Stack. And thank you for the quick turnaround. It means a lot.
Please sign in to leave a comment.