Greetings,
I'm interested in creating a custom expression using the Editor (not SQL) to sum the data for the last 7 days. Currently, I have the following SumIf expression:
SumIf([nb_ad_sync_load], between([time_scope_value], "2024-01-24", "2024-01-31"))
However, as I'm relatively new to this, I was wondering if it's possible to achieve the same result using a "relative" approach, specifically, for the past 7 days. If you have the expertise to guide me through this, I would greatly appreciate it.
Thank you.