Getting Min & Max Time in different Time Group

[ADSL]

Hi BI Community Team,

I have a table name "VISIT SUMM" that it has a record login and logout time of each sales rep and customer visited. 

In daily basic, we want to track the sales rep punch time -- min & max time with different time group below.

Any suggestion/advise?

Thanks and Regards,

[lbendlin]

Time_Session = SWITCH(TRUE(),
[TIME_IN] >= TIME(1,0,0) && [TIME_IN] < TIME(8,0,0), "Early Morning",
[TIME_IN] >= TIME(8,0,0) && [TIME_IN] < TIME(12,0,0), "Morning",
[TIME_IN] >= TIME(12,0,0) && [TIME_IN] < TIME(13,0,0), "Lunch",
[TIME_IN] >= TIME(13,30,0) && [TIME_IN] < TIME(17,30,0), "Afternoon",
[TIME_IN] >= TIME(17,30,0) && [TIME_IN] < TIME(21,0,0), "Evening", "Late Evening")

- The lunch interval is incorrect.

- [TIME_IN]  is a datetime value so all your Time_Session computations result in "Late Evening". Did you mean to use [Log_In]  ?

see attached

[ADSL]

Hi @lbendlin,

When we build visual with matrix, then getting wrong result between time session as the screenshot below.

e.g. Morning - 8h00 till 11h59

Please help to check and advise.