Forum Discussion
Getting Min & Max Time in different Time Group
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_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
