Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ayoubb
Helper IV
Helper IV

Count by TimeSLOT

Hello,, 

 

Thank you for your support and reply, 

time slot.JPG

Please could you help me to calculate reporting interactionID per timeslot by using the column Call end time:

06h-07h

07h-08h

08h-09h

09h-10h

10h-11h

11h-12h

12h-13h

13h-14h

14h-15h

15h-16h

16h-17h

17h-18h

 

2 ACCEPTED SOLUTIONS
ryan_mayu
Super User
Super User

@ayoubb 

Is this what you want?

timeslot = HOUR('Table'[call end time])&"h-"&(HOUR('Table'[call end time])+1)&"h"

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

@ayoubb 

right click the column in the value filed to change to count

1.PNG

Click three dot on the top right of your chart, choose sort by time slot and click sort by asc or des to show in order.

1.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

16 REPLIES 16
ryan_mayu
Super User
Super User

@ayoubb 

Is this what you want?

timeslot = HOUR('Table'[call end time])&"h-"&(HOUR('Table'[call end time])+1)&"h"

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thanks a lot RYAN, this is exactly what i want, this is below the result i just want to show that from 06h till 18h in chronological order, is this anything i need to add?

 

per slot.JPG

@ayoubb 

maybe try

column=
var timeslot =  HOUR('Table'[call end time])&"h-"&(HOUR('Table'[call end time])+1)&"h"
RETURN IF (HOUR('Table'[call end time])>=6&& HOUR('Table'[call end time])<=17), timeslot, "")




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




end time.JPG

Something goes wrong, please advise?

@ayoubb 

please try remove the closed bracket after number 17

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




dd.JPG

 i tried again, KO

Please advise

@ayoubb 

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,"")

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




rr.png

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 

 

Could you please create a chart in excel to show the expected output that you want?

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




I have a data base of entered like this one below with a column named "Call end time":

ss.JPG

 

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:

 

chart1.JPG

@ayoubb 

please created a column that I mentioned.

 

1.PNG

put any column in the value field and change to count

1.PNG

unselected blank value in timeslot

2.PNG

 

 

2.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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 ?

 

1111.png

@ayoubb 

right click the column in the value filed to change to count

1.PNG

Click three dot on the top right of your chart, choose sort by time slot and click sort by asc or des to show in order.

1.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




az38
Community Champion
Community Champion

@ayoubb 

do you have time slots list in a separate tables?


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

No i'm afraid i don't have this in a different column, i want to recover that from "Call end time"

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.