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.
2 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. :-)
Please sign in to leave a comment.