Stacked chart or comparing % difference between 2 tickets tags in the same week? | Community
Skip to main content

Stacked chart or comparing % difference between 2 tickets tags in the same week?

  • February 28, 2022
  • 1 reply
  • 0 views
J

Hello ZD Community,

 

I hope you are well.

 

I'm trying to create a stacked chart between 2 ticket tags that we record each week, a simple Yes/No Tag.

 

I either want a way to show a stacked chart with the % difference between the Yes/No or a better way to compare the Yes/No on a week by week basis in 1 chart.

 

Below is an example any help will be appreciated:

 

    1 reply

    Jacob20
    • Jacob20
    • March 2, 2022

    Hi Jack,

    I'm thinking you could create two custom metrics one that counts "no" and another that counts "yes", and then include them both in the same query, but there are still a lot of options available depending on what data you have available.

    • It looks like you're counting ticket updates, not tickets, is that correct?
    • Will the yes/no value be present on all tickets/ticket updates? Can both be present?
    • Are there tickets where none of these values are present, and should they be omitted?
    Terms & ConditionsCookie settingsAccessibility statement