This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I want to create a look that exclude all Mon to Fri 8am - 7pm, Means I still want the data on Mon - Fri but before 8am and after 7pm and also the weekends How can I do that?
Try using table calculations for this use case. Create 1st calc to extract hours from your time field (use function extract_hours() ) and 2nd calc over the 1st to provide a range condition like ${hours}>7 AND ${hours}<9. The 2nd one will give a yes/no output. You may now use the fields to show as per your choice, entire data will still be there.
Another option would be to use custom expression/filter option available on the look. You can pass your time range condition there to filter the values. But this will apply to the entire dataset in the look. Like this >
extract_hours(${timefield})>7 AND extract_hours(${timefield})<9
LinkedIn
Twitter
