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
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] ) )
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
Hey mate,All good it got worked out.
The formula required was > MAX( DDiff( [Days in Production Season Closing Date],Now([Days in Date1])))