• 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 Anastasia,
     
    This is so close – thank you for giving me such a good lead!
     
    My situation might be complicated because my season is done in rotating rep…the formula you mentioned below is almost perfect, except it gives me a total of 56 days between now and my closing night of June 26, when in fact that is 61 days away. I think it is choosing a different production closing date than the latest-closing show of the season.
     
    I know I can tweak the widget by setting a production season filter, but then it also limits my ticket revenue to just what that one show has brought in – making the daily “goal” amount much higher than it should be.
     
    Any other thoughts or ideas are much appreciated!
     
    Anh Le   (she/her/hers)
    Director of Marketing & PR
    Opera Theatre of Saint Louis | ExperienceOpera.org
    ale@opera-stl.org | (314) 963-4294
    .
     
     
  • $organization in reply to Anh Le

    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.

Reply Children
No Data