Good day all,
I've been experimenting with the Diff Past Month functionality in a widget to track our On Account funds. But rather than a "rolling month" (or "a month from today" which I think is what i get with this formula), I'm looking for a difference from a fixed date, so for example 8/31/21.
Is that possible?
Thanks!
Lesley
I vaguely remember there is a way to tell Analytics 'get today's date', but I can't remember how to do that. I'll see if I can dig that up. I'm not sure how to proceed beyond that point, but it might be helpful!
Paging Chris Wallingford- any assistance to provide?
Hi Anh,
Are you intending that this show the difference as an indicator widget, or is this in the context of some other visualization? For an indicator the formula could be constructed as the grand total minus the total prior to your specific date. E.g.
[Total Whatever] - ( [Total Whatever] , [Days in Date w/Calendar type filter From Earliest Date To 8/31/21] )
Hi Anh!
I'm not sure if this might be close to what you're after, but I'm using the below formula to work out that rolling daily sales target you're referring to and display it in an indicator widget
((sum( [Performance ID], MAX ([Budget Amount]) )) - [Total Ticket Paid Amount])
/
(MIN(DDiff([Days in Production Season Closing Date],NOW([Days in Production Season Closing Date]))))
I'm pretty sure this gives me Budget Amount - Total Ticket Paid Amount / Days Until Closing Date of Production. You could obviously replace the Budget Amount with just a fixed figure if you don't use that field!
I did some manual calculations against the figure this gives me and it seems to be accurate, so hopefully it might be of use to you
Cheers,
Anastasia
Data and CRM Specialist
RISING Melbourne
Try using MAX instead of MIN against the DDIFF. In the context of more than one production, it's returning the one that ends first within the season rather than the last.
Nathanael Pearson I saw your note above about telling Analytics to "get today's date", were you able to dig that up? I'm trying to set up a function that will update some hardcoded benchmark goals on the first of the month in a contributions (i.e. if current month = 7, then return 6000, if current month = 8, then return 7000) and right now I only seem to be able to use date fields that are linked to contributions (which is not ideal, since with the overnight load and our gift processing timelines, the "current month" of the most recent contribution may be behind by a couple days). Appreciate any insight you might have!