Comparing metrics to previous period

6 Comments

  • Hillary Latham
    Comment actions Permalink

    Hannah, you can tell individual components on your dashboard to ignore filters.  So when you add this query to a dashboard with a filter, in the query options, choose "Exclude filters" and exclude the dates.  https://support.zendesk.com/hc/en-us/articles/360034902733-Best-practices-for-using-dashboard-filters

     

    0
  • Hannah Voice
    Comment actions Permalink

    Thanks very much Hillary Latham, I'm aware of that option. 😊

    However, I want the query to adjust based on the date range. I just want the comparison to be based on the date range I've picked, rather than hard coded as last month compared to the previous month. For example:

    • If I set "today" in the date picker, I want the comparison to be between today and yesterday
    • If I set "last week" in the date picker, I want the comparison to be between last week and the week before
    • If I set "this month" in the date picker, I want the comparison to be between this month and last month

    Essentially, I want the comparison to be the period I selected and the period immediately preceding it. I feel like this is a pretty common use case and something that is usually available in reporting software. For example, here's how it looks in Google Analytics:

    And here in Help Scout:

    Date range calculated metrics are fixed to certain dates (not actual dates, but "month" or "week" for example). It seems very cumbersome to have to create multiple queries for every possible comparison you might want (e.g. comparing by day, week, month, quarter, year), so I feel like I'm missing something. 🤔

    Thanks!

    0
  • Hillary Latham
    Comment actions Permalink

    Apologies - I see I misread your original post.

    I don't know of a why to do this date comparison dynamically off the same query.  Does sound like a cool feature to possibly share on the feedback channel (I will vote for it!).

    In the meantime, the only thing I could think to do is to make multiple metrics for the previous comparison periods.  There are metrics for "tickets created past 7 days" and "tickets created past 30 days".  They use the "Date range calculated metric" feature - you could make several of your own and have that relative date (week, month, quarter, etc).  You could either make these separate queries that populate "boxes" on your dashboard, but all use the date range selected, or you can add all the metrics to the same query.  I don't see a way to dynamically choose the period.  But you could have several time periods on the dashboard together show them all at once versus changing it based on the user's choice.

    0
  • Hannah Voice
    Comment actions Permalink

    Thanks Hillary Latham! Appreciate your help. 🙌

    I also worked up an alternative that I'll share here in case it's useful for anyone else. Rather than using date range calculated metrics, I created standard calculated metrics and then configured the result path calculation to show the change between weeks.

     

    Then, on dashboard level, I added a change metric so I can toggle between week, month, and quarter. Video here.

    0
  • Hillary Latham
    Comment actions Permalink

    Yes, another great alternative.  I have done something like this before to show the differences between weeks.  I haven't tried toggle between month and quarter.  If you get something working well, I encourage you to submit a recipe - I think this is a useful type of query.

    0
  • Nicole - Community Manager
    Comment actions Permalink

    Great suggestion, Hillary! 

    Hannah, if you do get a recipe figured out, here's the information on how to write it up to share with other users: 

    How to write & submit a tip for the community 

    0

Please sign in to leave a comment.

Powered by Zendesk