Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
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
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.
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
66 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |