Average of tickets by hour question

MichaelClark
MichaelClark Wichita Falls, Texas ⚪️

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 Indiana 🥷
    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 Wichita Falls, Texas ⚪️
    Answer ✓

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

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴

    @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"