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 πŸ”΄
    Accepted 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.

  • MichaelClark
    MichaelClark Wichita Falls, Texas βšͺ️
    Accepted Answer

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

Answers