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