Chart types for comparing metrics

Have more questions? Submit a request

6 Comments

  • Gal Zohar

    Can you create a KPI that shows the difference between the last value and the one previous to that?

    I am trying to show "% Breached Tickets" this month (let's say it's 5%), vs the previous month (let's say it was 3%). I expect to see the difference is +2%, but as I only have one metric, it does not show any diff.

    I am probably doing something wrong? The guide above shows the use case with 2016 being the latest year, but it does not show how it compares to 2015.

    Thanks!

    0
  • Jessie Schutz

    Hi Gal!

    I've actually done this myself! You'll need to create two custom date range calculated metrics, one with a date rage for the current month and one for the previous month (or one month prior and two months prior, etc). Then you add both of those metrics to your report and choose the KPI visualization. If memory serves, there's a setting you'll need to enable that will display the % difference in addition to the up or down arrow, but I don't recall where it is off the top of my head. But that should get you where you need to go!

    1
  • Gal Zohar

    Thanks Jessie,

     

    That worked, I think.

    Now I am seeing another thing - is there a way to tell a KPI chart that "more is bad, less is good"?

    When it comes to % SLA Breached, having an increase of 5% is showing up as happy green, while it's very sad :) In this case, having a higher number this month, means we are trending in the negative direction...

    0
  • Jessie Schutz

    Hey Gal!

    If I'm not mistaken, from within the query, click on the on the chart configuration icon and then click Colors. That'll give you the option to change the color arrows to whatever you need. :)

    0
  • Gal Zohar

    Wow - that's quite obvious, and yet I didn't think about it. Oops :)

    Thanks Jessie!

    0
  • Jessie Schutz

    No problem! It can be hard to see stuff like that when you're neck deep in a new tool. :)

    0

Please sign in to leave a comment.

Powered by Zendesk