How can I filter a DATE_DIFF based on this week / last week rather than "nb_of_days"?

回答済み

投稿日時：2022年6月27日

Hello Community

I'm trying to build an explore query that filters based on this week and last week for a specific field being updated.

Is there a way I change this query to filter more accurately based on tickets update this week and a duplicate report to filter based on last week.

The last week should be easy as I can keep it as it is but how can I filter tickets updated this week without having to manually change it each week?

1件のコメント

日付

2022年6月28日

Hey Jack, interesting question!
I'm not aware of a way to include relative timeframes like "this week" into the formula.

Have you tried working with a Date Range calculated Metric?
You can check this out here: Date range calculated metric

This should allow to "lock" the result of the metric to the update - timestamp for this or last week.

サインインしてコメントを残してください。