• Replies 3 replies
  • Subscribers 962 subscribers
  • Views 58 views
  • Users 0 members are here
Related

Days Left In Campaign Formula

Iain Shand
$organization

Hi all,

Trying to show in a Dashboard how many days are left in our current Festival Campaign, and have that obviously update daily with a new number.

Is there a formula I can use to implement that?

Thanks,

Iain 

Parents
  • $organization

    Hi Iain,

    Campaign End Date is not a native field in Tessitura Analytics. Campaign Start Date is available. If we can relay on the campaigns being 1 year to the day, we could use a formula like that returns the number of days since the start of the campaign and then subtracts that from 365 days...

    365 - MAX ( DDIFF ( NOW ( [Days in Campaign Start Date] ) , (Days in Campaign Start Date] ) )

  • $organization in reply to Chris Wallingford

    Hi Chris,

    Thank you for replying to this. Unfortunately the campaign is not 1 year to the day. 
    We went on sale on the 17/3 and our first performance is on the 23/5 - so I'm looking to get something up that shows the days left between the current date and the 23/5. Not so much relying on the Campaign Start Date then, more on just using those dates.

    Sorry, that wasn't exactly clear in my first message.

    thanks

Reply
  • $organization in reply to Chris Wallingford

    Hi Chris,

    Thank you for replying to this. Unfortunately the campaign is not 1 year to the day. 
    We went on sale on the 17/3 and our first performance is on the 23/5 - so I'm looking to get something up that shows the days left between the current date and the 23/5. Not so much relying on the Campaign Start Date then, more on just using those dates.

    Sorry, that wasn't exactly clear in my first message.

    thanks

Children
No Data