Forum Discussion

wshao2's avatar
wshao2
Regular Visitor
5 years ago
Solved

How do I get hourly average?

Hi there,    I have tried to get an hourly average for the table below. I have multiple years' transactional records and below is a short version. I built the Year, Month, Date and Hour columns alr...
Need Help
  • wshao2's avatar
    wshao2
    5 years ago

    I ended up creating a separate table using the groupby function as I need the aggregated call volume specific for each hour/day/month/year. Something like this:
    Table = GROUPBY('table name', 'table name'[Hour],'table name'[Date], 'table name'[Weekday],'table name'[Month],'table name'[Year],
    "Calls Offered", SUMX(CURRENTGROUP(), 'Table Name'[Call Volume]))

    I added more columns to aggregate some other stats like talk time, AHT-HandleTime. It worked!

  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi wshao2 ,

     

    Yes, your method is also a good choice, congratulations! In addition, the method I provided can also be used as a reference to provide another way of thinking for you to encounter problems in the future. Hope to help you😁.

     

    Best Regards,

    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi wshao2 

Create a measure

Calculate(SUM('table'[Call Volume], ALLEXCEPT('table','table'[Year],'table'[Month],'table'[Date],'table'[hour]))