Customizing queries

Have more questions? Submit a request

16 Comments

  • Quentin
    Comment actions Permalink

    How can I edit colors based on the attribute's value? For example for "Ticket Status" in a bar chart I'd like to set "Open" as red, "On Hold" as black...

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Quentin,

    What you'll want to do is add the Ticket Status attribute under Rows and be sure to select the Ticket Status option towards the top left to highlight each status. From here you should be able to customize each of the values as shown in the screenshots I've provided below:

    Let us know if you run into any issues with the above. 

    Cheers!

    1
  • Quentin
    Comment actions Permalink

    hi Brett!

    Happy New Year!

    Thanks a lot for your reply! Exactly what I wanted :)

    0
  • Mary Beth
    Comment actions Permalink

    How do I use/view a dashboard I've created without being in edit mode? Preview?

    Thanks - Mary Beth

    0
  • Gail L
    Comment actions Permalink

    Hi Mary Beth,

    Thanks for reaching out! If you're viewing the dashboard in Explore, you'll have the option to edit a dashboard that you created. If you just want a static version to check on, I'd recommend scheduling an email delivery of the dashboard.

    Cheers,

    0
  • Mary Beth
    Comment actions Permalink

    Thanks, Gail. So, the only way I can view what other team members see is to email a version to myself? I had hoped for something different. :)

    1
  • Denielle Barcelona
    Comment actions Permalink

    How can I have a query that changes the data based on filters on the dashboard it's on? It looks like I can only filter on the query itself. I essentially want to be able to dynamically change the query result based on the dashboard filters (I set them as a bookmark).

    0
  • Gab
    Comment actions Permalink

    Hi Danielle,

    The filters set on a dashboard or a bookmark within a dashboard cannot be automatically carried over to the queries. The queries are independent of the dashboards. Changes on the dashboards, whether or not the reports are added as widgets, won't affect the setup of your queries.

    Thanks!

    0
  • Ayal Kellman
    Comment actions Permalink

    When I have more than one metric inside a query, is it possible to display the values of only one of the metrics? 

    Thanks!

    0
  • Kyle Jones
    Comment actions Permalink

    Hey there Ayal,

     

    That's a very good question! You can isolate this data by using something called a Datatip, when added to your query datatips appear when viewers hover over a data point. By default, datatips contain the value of the data point. In the chart configuration menu, you can change the format and text in your datatips.

    In the chart configuration menu, select Datatips.


    1. Check the Show datatip box.
    2. In the Mode drop-down list, choose either Datatips or Comparison line

    If you want to add an element from your query, select metrics or attributes from the Select an element to add drop-down list.

    I brought in the relevant information, but I would also recommend checking out the article this is housed in over here: https://support.zendesk.com/hc/en-us/articles/360022183934

    0
  • Kristel Kos
    Comment actions Permalink

    How can i adjust the font size of the titles?

     

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Kristel,

    Once you add your query to a dashboard you can edit the font size of the header as shown in the screenshot below:

    Let me know if you run into any issues locating this option!

    0
  • Joe Gran
    Comment actions Permalink

    I have a Ticket Count by Date Line graph. I've added a "Ticket Category" dimension to the Rows section, which easily allows me to see the trend of each category I select over time.  

    The y-axis, however, does not auto-scale when I select a category that is far lower than the total tickets for a given day. Is there a way to auto-scale the axis based on the data being displayed?

    0
  • Devan
    Comment actions Permalink

    Hello Joe Gran,

    You can accomplish this by implementing the following in your Explore instance. 

    1. Navigate to the Chart Configuration menu
    2. From there navigate to the Y-Axis menu 
    3. Locate the Shared Access box
    4. Uncheck it 

    I've included an image that should help you identify this on your set up. 

    Best regards. 

    0
  • Comment actions Permalink

    How do you edit the x and y axis labels?

    0
  • Rob Stack
    Comment actions Permalink

    Hi Niall Adler - Mission College 

    To edit the axis labels, you double-click the existing label and a note box will pop up where you can enter the new text.

    I'll make sure this information is included in this article. Thanks!

    0

Please sign in to leave a comment.

Powered by Zendesk