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.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi wshao2 ,


According to your needs, you might as well try to create the following measure: group and summarize the Call Volume value according to the Hour field.

 

Total Call Volume = 
CALCULATE (
    SUM ( 'Table'[Call Volume] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Hour] = MAX ( 'Table'[Hour] ) )
)

 

If the problem is still not resolved, please provide detailed error information and let me know immediately, looking forward to your reply.


Best Regards,
Henry


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

wshao2's avatar
wshao2
Regular Visitor
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
    Community Support
    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.