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.
Tip: The following procedure affects the columns generated by attributes added to the Columns panel of the query. If there are no attributes in the Columns panel, don’t use these options. If you are using the Table visualization, you can choose Chart Configuration > Tables to remove any columns you don’t want. For more information, see Working with 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.
17 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.
On Wednesday, April 8, from 8:00am-10:00pm CDT, we'll have a special guest team of experts on hand to answer your questions about Explore: Reporting & Insights Migration in your Zendesk Explore instance for an AMA-style conversation!
Just click the "new post" button and write up your question. Be sure to be as detailed as possible. The best questions include:
Questions posted to this topic in advance of the start time will be answered first thing on the 8th, so if you've got something you want our experts to look at, post it today!
Hey Rob,
How do you hide on this query "#Tickets" header?
Hi James. Once you've created the chart, go into the Display format menu (second icon down on the right of the screen) and click Y axis. Once you're in the Y axis menu, click "Hide Y axis title"
Hope that helps!
Your the best! Feel free to take the rest of the day off....
Ha ha, thank you :-)
Eric Haley How did you end up resolving the issue where all of your data disappears when hiding columns? I'm running into that too.
Sorry if I'm just missing this. How do you hide an entire metric?
I'm not seeing this functionality: https://support.zendesk.com/hc/en-us/articles/360047742213-Can-I-hide-the-metrics-column-in-an-Explore-query-table-
Hi Nate Spataro thanks for the question. You'll find that functionality in this article - https://support.zendesk.com/hc/en-us/articles/360022366313
Thanks for the blazing fast response Rob Stack! It looks like this article is also suggesting using a Columns area that I don't see in Explore. Here is what my chart configuration looks like.
Hi,
Is it possible to hide a column from a table query from both the query itself and from an export?
For example, in my table query I have COUNT(Tickets) as the metric and went to Chart Configuration > Columns to hide the column from viewing in the query itself. However, the COUNT(Tickets) still appears when exporting.
Hi John,
This is expected behavior when hiding columns via chart configuration>>columns. Instead, you'll want to hide the preferred column by going to result manipulation>>hide part of your result. Hiding columns here will be respected in exports.
Hope this helps!
Please sign in to leave a comment.