I want to fetch count of data for a specific time frame (mon-fri)-(9-17)

Dheeraj_1996 · 2023-05-31T18:18:57+00:00

There was an error rendering this rich post.

Dheeraj_1996

I have data for all hours in a day, but I want to filter out data from only business hours mon-fri (9-17)

Find more posts tagged with

Accepted answers

MichelleH

@dheeraj_sandhanshi You can set up a beast mode like this to segment what data to filter:

case
  when DAYNAME(`DateField`) in ('Saturday','Sunday') then 'Exclude'
  when HOUR(`DateField`) >= 9 and HOUR(`DateField`) < 17 then 'Include'
  else 'Exclude' 
end

All comments

MichelleH

@dheeraj_sandhanshi You can set up a beast mode like this to segment what data to filter:

case
  when DAYNAME(`DateField`) in ('Saturday','Sunday') then 'Exclude'
  when HOUR(`DateField`) >= 9 and HOUR(`DateField`) < 17 then 'Include'
  else 'Exclude' 
end

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of