Date filter

TMonty0319 · 2023-12-11T13:27:04+00:00

There was an error rendering this rich post.

I have data that has reporting data for every day. I need help creating a quick filter on dashboard when i select it and see last 7 days

Find more posts tagged with

Date

Filters

Accepted answers

GrantSmith

CASE WHEN `Date` >= CURRENT_DATE() - INTERVAL 6 DAYS AND `Date` <= CURRENT_DATE() THEN 'YES' ELSE 'NO' END

This will check if your date is within today and 6 days ago (Tuesday - Monday using today as an example) You can tweak it if you want to look at 1-7 days ago.

All comments

GrantSmith

CASE WHEN `Date` >= CURRENT_DATE() - INTERVAL 6 DAYS AND `Date` <= CURRENT_DATE() THEN 'YES' ELSE 'NO' END

This will check if your date is within today and 6 days ago (Tuesday - Monday using today as an example) You can tweak it if you want to look at 1-7 days ago.

TMonty0319

Great thanks!

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of