I have a dataset that is aggregated by a calendar week number. How could I ensure that when a user goes to view a respective card, that they see the most recent week (even if the dataset hasn't updated in 2 or 3 weeks?)
i.e. the user views the card in week 15 but the dataset hasn't updated since week 13. So I would want the user to see week 13 (the most recently updated week). I couldn't apply show previous week filter since its two weeks away, right?
I also would like to know if anyone has any thoughts on how to apply an alert to one of these cards when the dataset updates and would send out the updated week only.
Thanks for all your help Domo community!