Hi
I’m trying to build a look/table which shows a measure for current day value, as well as an average of the last 7 days. The issue is this measure is a “number” type cuz it’s a calculation of division. So I’m having trouble creating this measure with filters of date_day_date. Is there any other ways to have the same measure but applied with different time frame/filter in the same look/dashboard?
Thanks!
I think you can achieve your goal by creating two custom fields along with a date filter on your explore.
Suppose you have a measure that represents the value per day. In my example - Count.
To create current day value, you can create a Custom measure with the following custom filter :
${history.created_date} > add_days(-1,now())
To create Last 7 days Average, you can create a Table calculation with the following Custom Expression:
round(${history.count}/7,1)