Hi Guys,
I have a data set with bunch of time slots and need to group them into night and day category.
Can you please suggest on how to put them in night and day category ?
This is the logic :
DAY
check current time
if curr_time between 7am & 6.59pm
pull Data date = curr_date and Data time between 7am & 6.59pm
NIGHT
if curr_time >= 7pm
pull Data date = curr_date and Data time between 7pm & 11.59pm
NIGHT
if curr_time between 12am & 6.59am
pull Data date = curr_date and Data time between 12am & 6.59am AND Data date = curr_date-1 and Data(yesterday date) time between 12am & 6.59am
How can I apply this on calculated field
Thank,
Farz
@farz TJ you can do that by creating groups - see See it your way: FAQ Series - Creating Groups (jimdehner2.blogspot.com)
give it a try and if there are still question post your twbx here so we can see what you have done
If this posts assists in resolving the question, please mark it as “Best Answer” or Upvote.
Also please help use better track your reply by including a mention to the volunteer who provided the answer – mine is @[Jim Dehner]
Thank you.
Jim
