Best Of

@user000051, posting your questions and approaches to business problems in the Dojo is a great way to verify and refine your beast modes and other features. There are some great minds available here.

Thanks dthierjung for the write-up. I'll have a look tomorrow to see if using the previous day calculation to get the internal day value works for me, and report any futher updates that I may notice. The dataset 'campaign_schedule_date_local' just has date.

Hey, sorry if not made clear.

At the moment, depending on when the user views the cards, some of the records that make up the overall DoD value are from the previous day and some from the current day. So for DoD, I want to take the records up to '23:59:59' for each day, creating an internal day view. 

@Tow solving it yourself is always good and either way you've made @GrantSmith a happy man :P