Adding metrics and attributes to queries

Have more questions? Submit a request

10 Comments

  • Hillary Latham

    What is the metrics panel that you reference?  The only "metrics panel" I see is the one on the left to add metrics and there are no options for charge configuration.  I have a column chart type in my query.

    0
  • James Sanford

    Hey Hillary!

    Metrics panel refers to the highlighted panel in the below screenshot on the left side of the Query builder where you can add Metrics to your Query.

    Chart Configuration is found on the right side of the Query builder and is highlighted in the below screenshot for you as well.

    0
  • Hillary Latham

    Let me ask in a different way, I do not see anything that looks like a dual axis icon in the Metrics panel.    How can I select a metric to be on the dual access from the Metrics panel?  I do not see a way to do what your instructions say.

    0
  • Laura Weiler

    Can you add a dual axis where one side is a count (total tickets) and the other side is a percent (% satisfaction score)? I am trying to slice the data by ticket reason. I can get one metric or the other to display the way I want, but I cannot get both onto the same query displaying in a way that makes sense. It keeps stacking the % satisfaction scores in one column for all ticket reasons instead of matching up with the column that represents the ticket count for that reason.

    0
  • Jessica Blake

    @Hilary, you should be able to select a dual axis when two metrics are selected. You can select dual axis either from the icon in the metrics panel, or within the metric itself. Check out the screenshot below which should help.

    @Laura you can definitely use dual axis when the metrics are not measuring the same attribute like your example of count vs percentage. I recommend that you check out the Explore recipe Reporting on CSAT and one-touch tickets which will help with changing the axis so that the percentage value displays correctly. It's very similar to your use case.

    Let me know how you go!

    1
  • Ayal Kellman

    Hi - is there a way to sort the explosion attribute? 

    I want to explode by ticket priority and its showing Normal, High then Urgent. Is it possible to invert that sort order? I tried a few times using the result manipulation functions but that only seems to work on metrics not on the explosion...

    Thoughts?

    0
  • Andy Merrick

    Hi Ayal!

    Adding attributes into the Explosions panel will break your report out into individual charts. You can then use the result manipulation functionality to sort the results in each chart, but not the order of each individual chart.

    If you're looking to order the ticket priority results in a particular way, you could consider creating a new query for each priority and ordering them how you wish on a dashboard.

    0
  • Sara Gardinier

    I'm wondering if there is a way to "save" a list of assignee's that I can apply across queries. Right now our dataset includes numerous assignees but I only need reporting for six people. Each time I create a query where I want the results broken down by assignee, I have to search for each name and manually select it. Is there a way to save that selection of assignees so that it can be applied more easily?

    0
  • Rob Stack

    Hi Sara, one way you could do this would be to set up a standard calculated attribute that tests for the assignee names you want. This would look something like this (add a new "ELIF" line for each assignee):

    Then, use this attribute instead of the standard "Assignee name" attribute.  Hope this helps!

    1
  • Sara Gardinier

    Thank you, Rob!

    1

Please sign in to leave a comment.

Powered by Zendesk