Working with tables

Have more questions? Submit a request

12 Comments

  • Judd Higgins
    Comment actions Permalink

    Can you please add the ability to color select individual cells in Tables?  I have a Table Chart for Individual Satisfaction Scores and since I cannot choose which columns add up or give the average for, I need the ability to color the selected cells that we need to be aware of (See example chart below)

    Ideally I'd be able to hide the data I do not want in the chart, but the Hide features in Explore only apply to Entire Columns or Entire Rows.

    Thanks!

     

    0
  • Lotte
    Comment actions Permalink

    In some cases, I would like to be able to sort on attributes instead of metrics. For example when I create a table displaying a certain group of tickets, I want to sort them on created date rather than ticket count (since this is 1 on each row anyways). Is this possible somehow?

    0
  • Kyle Jones
    Comment actions Permalink

    Hey there Lotte,

     

    That's definitely a very good question! There are a few different sort options you're able to do for chart styled reports. I'd recommend giving the A-Z sort a try (but your report would need to be for ticket creation/creation date), by default this would pull oldest to newest, but if you'd like this changed a Z-A sort will reverse that.

     



    If this doesn't achieve what you're looking for. Definitely let us know!

    0
  • Adam Nattrass
    Comment actions Permalink

    I have a simple table that shows the amount of accepted, missed and declined calls an agent has for the previous day.

    I need to be able to sort the table by the agents name alphabetically to make it match up with another table I have for the total amount of tickets. 

    There only seems to be the option to sort the columns with data in and not the agents name. Is there any way to do this? I have tried using the result manipulation > sort but this only seems to affect the data columns rather than the agent name column.

     

    1
  • Jessica Blake
    Comment actions Permalink

    Hi Adam,

    By default the table should be displaying the agents' names in alphabetical order. It could be that one of your filters is affecting the order the names are appearing in.

    I'll send you a ticket so we can have a closer look!

    0
  • Jessica Hansen
    Comment actions Permalink

    My organization has a fiscal year of Oct to Sept. I'm generally asked to report by fiscal year. I'm able to set that date range but but is there a way to reorder the columns in a chart that is showing by month so that is it Oct to Sept instead of Jan to Dec? Just to avoid confusion...

    I'm using Ticket Created - Month

    0
  • Jessica Blake
    Comment actions Permalink

    Hi Jessica,

    You'll just want to add the attribute 'Ticket created - Year' to your columns, then the table should be ordered from October - September. 

    Let me know how you go!

    0
  • Andrei Kamarouski
    Comment actions Permalink

    Hi, 
    How do I make visible attributes values on each row in the table (for Month and Date Ticket Solved in my case)? I know that putting Ticket ID as a first column will do this, but I want to keep it on 3rd one.

     
    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Andrei,

    I did some testing on my end and it looks like there's no way to change how this displays at this time. The attribute will be grouped by month instead of showing that month for each individual row. I'm happy to pass this along to our Explore Product managers as product feedback so they are aware of this need.

    I also encourage you to create a separate post in our Explore Product Feedback topic as this will help our PM's gauge interest in this functionality.

    Appreciate you taking the time to share this with us!

    1
  • Andrei Kamarouski
    Comment actions Permalink

    Hi Brett - Community Manager
    Thx for looking into my request! I submitted the idea too :)  

    0
  • Kirsten Johnson
    Comment actions Permalink

    Is there a way to have alternating row colors across multiple columns? Currently the "alternating rows" color option only affects a column displaying the metric. I'm hoping to improve readability of the chart, so I'd like to be able to have alternating colors across all columns. 

    0
  • Devan - Community Manager
    Comment actions Permalink

    Hello Kirsten Johnson,

    In Explore the ability to have alternating row colors as you described isn't possible as the base program stands. I would recommend, however, letting our development team know via our Product Feedback forum about your request so that they can consider adding it to their roadmap for future updates.

    Best regards.

    0

Please sign in to leave a comment.

Powered by Zendesk