I'm trying to show a featured image on my homepage. This image will be pulled in by a view that returns 1 result. I then change the caching of the view to 1 day.
What I would like is for each time the cache resets the view to return the next row.
Day 1 - image 1
Day 2 - image 2 etc..
I can add the sort criteria: 'Global: Random'. But then you have the chance that some images might be shown on consecutive days and that some are hardly ever shown.