At CHART TYPE "Single Value",
I would like to display the results up to last week.
Please tell me how to do this.
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 that's great to hear. If you can mark accept any answers that helped you, that will help others in the community.
No, you should select Flag. Under my replies, you should see something like this:
Click on Yes to accept it as an answer.
The script you gave me helped me accomplish what I wanted to do!
Thank you! It will be a great learning experience.
@MarkSnodgrass How do I mark this topic? Should I select "Flag"?
@MarkSnodgrass Understood, thank you for sharing!