Customizing queries

Have more questions? Submit a request

10 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 Leinweber
    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

Please sign in to leave a comment.

Powered by Zendesk