Average of tickets by hour question

I have a card Daily Ticket Flow that has Count of tickets by hour for the previous week. My users want to see an Average of tickets received for that hour instead of actuals. I saw something in the old Community platform about Beast Mode using buckets and then averaging the bucket. Any thoughts?

Thanks in advance!

Michael


Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @user030156 / Michael

    I'd recommend using a dataset view (talk to your CSM to join the beta if you don't already have it) to calculate the date and hour of your timestamp.

    Date:

    DATE(`Timestamp`)
    

    Hour:

    HOUR(`Timestamp`)
    

    Then group based on these two fields (date and hour) and count the number of tickets you have using the COUNT aggregate within your dataset view.


    Then using the dataset output from this view in your card you can use the Hour field as your X axis and then take the AVERAGE of your count field to get the average per hour over the last X days based on your card filter.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MichaelClark
    MichaelClark Member
    Answer ✓

    Excellent suggestion and I appreciate the exposure to the dataset view!!

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @user030156 / Michael

    I'd recommend using a dataset view (talk to your CSM to join the beta if you don't already have it) to calculate the date and hour of your timestamp.

    Date:

    DATE(`Timestamp`)
    

    Hour:

    HOUR(`Timestamp`)
    

    Then group based on these two fields (date and hour) and count the number of tickets you have using the COUNT aggregate within your dataset view.


    Then using the dataset output from this view in your card you can use the Hour field as your X axis and then take the AVERAGE of your count field to get the average per hour over the last X days based on your card filter.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • @user030156 , change your aggregate in analyzer from the default of SUM to AVG.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • MichaelClark
    MichaelClark Member
    Answer ✓

    Excellent suggestion and I appreciate the exposure to the dataset view!!