Thanks both for your responses, I'll find a way to adapt. It's only one day's worth of data in the grand scheme of things but understanding the logic helps! 

Hey all, i use a report that provides a new row for each day that i extract and use to build a report. As the end of the year is coming up, i'm not sure how the report will behave with the time filter i have applied which is the pre-set adobe This Year (excluding today) - On January 1st 2024 will th...