Forum Discussion
ayoubb
Helper IV
Helper IVCount by TimeSLOT
Hello,, Thank you for your support and reply, Please could you help me to calculate reporting interactionID per timeslot by using the column Call end time: 06h-07h 07h-08h 08h-09h 09...
ayoubbHelper IV
Helper IVi tried again, KO
Please advise
ryan_mayu
Super User
Super Userplease take a look at this.
Column =
VAR timeslot = HOUR('Table (2)'[callendtime])&"h-"&(HOUR('Table (2)'[callendtime])+1)&"h"
return if(HOUR('Table (2)'[callendtime])>=6 && HOUR('Table (2)'[callendtime])<=17, timeslot,"")- ayoubb
I have done exactly what you said, but the result in chart should be:
from 06h-07h till 17h18
and not to depend to how many hours taken!
- ayoubb
I have a data base of entered like this one below with a column named "Call end time":
i want to do a chart like this one below that respect chronological order from 06h-07h till 17h-18h, and count how many entered by slot, like you see below:
- ayoubb
where to find to change it to count,
please take a look and tell me if this is what you asked exactly, the slot still not organized chronogicaly ?