• 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
    .
     
     
Reply
  • $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
    .
     
     
Children