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.
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.