Choosing metric aggregators

Have more questions? Submit a request

5 Comments

  • Chris Wooten
    Comment actions Permalink

    I am new to this Software but have been using Power BI for years. I am not sure why the program will not allow me to make averages of simple metrics such as the number of tickets solved per person.

     

    0
  • Rob Stack
    Comment actions Permalink

    Hi Chris, I'm sorry for the late response.

    One way you could do this is (using the Tickets dataset) to add the metric SUM(Tickets solved - Daily average), and then add Assignee name to the Rows panel.

    I hope this helps,

    0
  • Job Thomas
    Comment actions Permalink

    How can I rather than looking at the MED look at the 90% percentile for example? In our case, that's a lot more telling than the MED and it's much more the metric we would want to check.

    2
  • Alex Engel
    Comment actions Permalink

    Does SUM() round up to the nearest integer? One metric of ours is supposed to be 9.5 but instead displays 10.

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Alex,

    I confirmed with one of our Explore experts and it looks like most aggregators would round up to the nearest integer by default. If this isn't the desired result for you, you'll want to manually change the decimals places via the Chart Configuration>Display format

    Let me know if you have any other questions :)

    0

Please sign in to leave a comment.

Powered by Zendesk