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

Answered

1 Comments

  • Matt

    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. 

    0

Please sign in to leave a comment.

Powered by Zendesk