How to display results up to last week

Keisuke_n01

At CHART TYPE "Single Value",

I would like to display the results up to last week.

Please tell me how to do this.

MarkSnodgrass

You can create a beast mode that will look at the current date and then move it back to the last day of the previous week and then compare it against your date field.

CASE WHEN `date` <=
/* last day of the previous week */
     DATE_ADD(DATE_SUB(CURRENT_DATE(), INTERVAL 1 WEEK)
     , INTERVAL (7- DAYOFWEEK(CURRENT_DATE())) DAY) 
THEN 'Include'
ELSE 'Exclude' END

You would then drag this beast mode into your filters section and select Include.

MarkSnodgrass

@Keisuke_n01 that's great to hear. If you can mark accept any answers that helped you, that will help others in the community.

MarkSnodgrass

No, you should select Flag. Under my replies, you should see something like this:

Click on Yes to accept it as an answer.

MarkSnodgrass

You can create a beast mode that will look at the current date and then move it back to the last day of the previous week and then compare it against your date field.

CASE WHEN `date` <=
/* last day of the previous week */
     DATE_ADD(DATE_SUB(CURRENT_DATE(), INTERVAL 1 WEEK)
     , INTERVAL (7- DAYOFWEEK(CURRENT_DATE())) DAY) 
THEN 'Include'
ELSE 'Exclude' END

You would then drag this beast mode into your filters section and select Include.

Keisuke_n01

The script you gave me helped me accomplish what I wanted to do!

Thank you! It will be a great learning experience.

MarkSnodgrass

@Keisuke_n01 that's great to hear. If you can mark accept any answers that helped you, that will help others in the community.

Keisuke_n01

@MarkSnodgrass  How do I mark this topic? Should I select "Flag"?

MarkSnodgrass

No, you should select Flag. Under my replies, you should see something like this:

Click on Yes to accept it as an answer.

Keisuke_n01

@MarkSnodgrass Understood, thank you for sharing!