Recent searches


No recent searches

Working with tables



image avatar

Rob Stack

Zendesk Documentation Team

Edited Jun 21, 2024


1

19

19 comments

Hi Zendesk - I'm using the "Hide part of your result" feature for displaying raw data.

If I hide the first 3 rows, I get one row of data and then my totals:


If I hide the first 4 rows, then nothing displays.



My goal is to just have the totals displayed. Any ideas? Thanks!

0


Hi, 

I have used the belle vue theme and we are trying to change the category page to show in rows instead of columns.   Please can you advise how I can change this.   Thanks

0


image avatar

Tipene Hughes

Zendesk Developer Advocacy

Hi Jessica,

Thanks for reaching out!

I see you've created a standalone community post for this - I'll go ahead and reply directly to you there.

Thanks!

Tipene

0


I am wanting to sort by Assignee name, but clicking on the column header is only giving me a box to rename, it is not sorting.

 

I have made sure "Allow column sorting" is checked, but still not working.

0


image avatar

Elaine

Zendesk Customer Care

Hi Dana,
 
From the article Sorting results, it is mentioned there that the results in a Table query are displayed in the original order of the defining attribute.
 
The defining attribute is actually the first attribute listed in the Rows section within a query as seen in the screenshot below:

 
Based on the screenshot you have provided, the defining attribute is as follows:

 
If you want to sort the query on the Assignee name attribute, you will have to transfer the said attribute on top of all the attributes in the Rows section.
 
The Allow column sorting is only applicable for Metrics and not for Attributes.
 
Feel free to read through the Sorting results article that I linked above for more information about sorting within queries. Hope this helps! :) 

0


I want to use the arrow function in a table, which displays number of tickets solved per assignee (on rows), broken down by month (columns). 

The arrows are only showing = or green, but there are clearly declining values in the table so there should be some red arrows Month on Month. Why isn't there? 

0


image avatar

Giuseppe

Zendesk Customer Care

Hi Kristin,

 

In order to effectively use the Arrows, you'll have to use this with Result path calculations. This will allow you to have a path and reference for the arrows.

Here's a recipe that you can follow for this setup - How do I add a column in my query for the result path calculation?

0


Thank you Giuseppe, that worked! 

Could be a good idea to add the link to the article you just shared in this article where it mentions arrows. 

0


Thanks for the feedback, Kristin! I've alerted our documentation team :)

0


Is there a way to use metrics, rows, and tables in Explore to generate a query that shows all tickets that have one attribute AND another attribute? I am trying specifically to find all tickets that have a specific tag AND a specific other tag.

0


image avatar

Marco

Zendesk Customer Care

Hi Alex, 
 
Good question! For this, you will need to create a custom metric which would look something like IF (INCLUDES_ALL([Ticket tags], "united_states","italy")) THEN [Ticket ID] ENDIF. You may check this article here for more information: https://support.zendesk.com/hc/en-us/articles/4408838151450-Reporting-with-tags#topic_q5d_dms_jkb
 
Hope this helps! Cheers! 

0


I'd like to turn off totals sorting altogether. We have no use case where sorting should include moving the totals on the table. How do you lock the totals to the bottom of the chart?

0


Hi mfg,
 
You can turn off sorting entirely (turn off Chart configuration > Columns, deselect Allow column sorting), but if sorting is enabled, then Totals will be sorted along with the other data. I'd suggested creating a post in our Feedback - Reporting and analytics (Explore) topic, using this template so our product team gets the information they need.

0


Is there a way to increase the width of the columns that contain multiline? When you select multiline it removes your ability to increase the width of the column so someone has to scroll to read the rest instead of making it a little wider.

 

 

0


Hello Team, 
Is there a way to add 2 columns on a table where 1 is 'Tickets' and the other is 'Tickets with certain tags'? As in the metrics, they are only 1 item (Tickets) but in the table, I want to split them into all tickets for 1 column and tickets with certain tags for the other column. 

0


image avatar

Zsa Trias

Zendesk Customer Care

Hello Moe,

You can create a metric to return the number of tickets which has a certain tag and add both the COUNT(Tickets) and your newly created metric in your report. You can follow the instructions here: Reporting with tags

0


image avatar

Zsa Trias

Zendesk Customer Care

Hello Aaron, 

You must disable "Fit to content" to be able to input the custom width for your columns. 

0


Hi Team

Is there an option to sort based on rows? The column sorting checkbox is selected. We have a 'Solved Ticket' row and want to sort the results based on this row value - from new to old. The sort function is not working however, Is there a way to do it?

0


image avatar

Dane

Zendesk Engineering

Hi Nikita,

It's only possible for rows under the column of the selected metric.

0


Please sign in to leave a comment.