• Replies 14 replies
  • Subscribers 701 subscribers
  • Views 584 views
  • Users 0 members are here
Options
Related

"difference to date" in an indicator widget

Lesley Chaney
$organization

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 

Parents
  • $organization
    Hi Chris,
     
    I’ve played around with this idea below, but I can’t get anything to work.  Here’s the non-Analytics formula of what I’m trying to do:
     
    [Revenue Goal – Revenue to Date) / (Number of days left in sales campaign)
     
    Is there any formula you can recommend to calculate the number of days between “today” and a future date that would work in this context?
     
    Anh Le   (she/her/hers)
    Director of Marketing & PR
    Opera Theatre of Saint Louis | ExperienceOpera.org
    ale@opera-stl.org | (314) 963-4294
    .
     
     
Reply
  • $organization
    Hi Chris,
     
    I’ve played around with this idea below, but I can’t get anything to work.  Here’s the non-Analytics formula of what I’m trying to do:
     
    [Revenue Goal – Revenue to Date) / (Number of days left in sales campaign)
     
    Is there any formula you can recommend to calculate the number of days between “today” and a future date that would work in this context?
     
    Anh Le   (she/her/hers)
    Director of Marketing & PR
    Opera Theatre of Saint Louis | ExperienceOpera.org
    ale@opera-stl.org | (314) 963-4294
    .
     
     
Children
  • $organization in reply to Anh Le

    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 Slight smile

    Cheers,

    Anastasia

    Data and CRM Specialist

    RISING Melbourne