Hiding rows and columns

Return to top

14 Comments

  • John Tieu

    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.

    0
  • Taylor Bowser
    Zendesk Customer Care

    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!

    0
  • Puneet Misra

    Hi, 

    How can I hide the tickets column from a COUNT(Tickets) Metric? I am not using columns on my report but there is a column for tickets that is populated with 1 representing every ticket ID. I am using the ticket ID and subject as rows. (screenshot below)

    0
  • Stephen Belleau
    Community Moderator
    Zendesk Luminary

    Hey Puneet Misra - it's this part of the article that you'll want to refer to:

     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.

     

    FYI this will hide the metrics column in Explore, but I believe exports / schedules will still show it.

    0
  • Puneet Misra

    Stephen Belleau Can you elaborate on the steps? I am using the tables visualization type and I do not see tables under Chart Configuration and the steps in the Working with tables. do not have the information that is helping get the desired result. 

    0
  • Stephen Belleau
    Community Moderator
    Zendesk Luminary

    Puneet Misra oh you're right! The article needs to be updated. cc: Rob Stack

    It is Chart Configuration > Columns that you want.

    0
  • Rob Stack
    Zendesk Documentation Team

    Hi sphen, I'm opening a ticket to have the current Explore writer take a look at this. You should hear back soon. Thanks!

    0
  • Erin O'Callaghan
    Zendesk Documentation Team

    Hi Stephen Belleau and Puneet Misra, thanks for pointing this out! The article has been updated to state that you can use Chart configuration > Columns, just like Stephen Belleau said. :) 

    1
  • Casey

    Hi Zendesk - When hiding a part of a result (row), changing this value sometimes hides all of my results. For example, I am using a basic ticket count query and displaying totals:

    The image below has the first 14 rows hidden, but if I hide the first 15, then only the Total is displayed (deleting both of the 29 Sep 21 and 30 Sep 21 row sets). I would like the values for "30 Sep 21" displayed in addition to the Total (to show the current date that the data is for). Thanks in advance!

    0
  • Christophe Tiraboschi
    Zendesk Customer Care
    Hi Casey,
     
    I will create a ticket on your behalf so we can investigate this. 
     
    Thank you for bringing this to our attention.
    0
  • Casey

    Thank you Christophe Tiraboschi !

    0
  • Casey

    Hi Zendesk - Is there any way to display only totals from a query without having to hide rows/columns?

    I currently have totals displayed, but with hidden rows (=31) the total disappears for those months with 30 days (or less). It is a rolling "look-back" query to previous month(s), so the number of days/rows in the query will fluctuate.

    Thank you!

    0
  • Casey

    Please disregard my previous post - was able to figure it out by removing "Metrics on Rows" from Configuration and using "Top/Bottom" on Result Manipulation.

    0
  • Gabriel
    Zendesk Customer Care
    Hi Justin!

    I hope all is well! 
     
    Currently, you can only work with the option presented in this article to achieve that. For the moment, this functionality works with the "Hiding" concept, which, consequently, you can display the remaining rows and columns.  
     
    Thanks!!
     

     
    0

Please sign in to leave a comment.

Powered by Zendesk