Duplicate data points for Weekly Reporting. I need the most recent day for weekly reporting.

Our subscription data is collected on multiple days throughout the week and creates a snapshot of that point in time. I want to see what that week's total was based on the most recent day. I don't mind removing the row with an earlier start date.

Screen Shot 2022-06-23 at 5.16.52 PM.png


Comments

  • Not sure if this is the best solution but I ended up connecting it to the Domo calendar. Once I joined that I just selected 1 dayName in the filter.