hourly calendar
2 Topics
Average answer time for chat messages
Hi, i want to find average answer time for a spesific group. Receivers may be change, i should examine all conversations seperately. Table is like that: sender_id receiver_id date-hour spesific_group 2 1 01.01.2022 09:00 No 1 2 01.01.2022 09.10 Yes 1 3 02.01.2022 10:00 Yes 3 1 02.01.2022 13.00 No 1 3 02.01.2022 13.30 Yes 5 6 02.02.2022 15.00 Yes 6 5 02.02.2022 15.30 No 5 6 02.02.2022 15.40 Yes for ex, sender 1's average answer time is 10 minutes from the conversation with 2 and 30 minutes from the conversation with 3. It means that average answer time for 1 is 20 minutes. And for number 5, average time is 10 minutes. I hope I have been able to explain, thank you If it's too complicated I'm open for another approximate solutionsSolved837Views0likes1CommentTime intelligence methods for hourly calculations
So, here is a measure that works just fine when I'm using the Daily calendar. What could be the possible directions for doing the same when using Hourly calendar? Cumulative sum = CALCULATE ( [Measure], CALCULATETABLE ( SAMEPERIODLASTYEAR ( DATESYTD ( 'Daily calendar'[Date], "31/03" ))))Solved990Views0likes3Comments