Hiding rows and columns

Return to top

11 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

    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

    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

Please sign in to leave a comment.

Powered by Zendesk