Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
3 years ago

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 -- min & max time with different time group below.

 

 

Any suggestion/advise?

 

Thanks and Regards,

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago
    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's avatar
      ADSL
      Post Prodigy
      3 years ago

      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.