Forum Discussion
Solved
Count 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...
please 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,"")
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!
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:
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 ?