Hi there - I am trying to figure out how I can include a countdown to show date value in an analytics dashboard I'm working on. I've tried several things, but just can't manage to figure out how to get this. Has anyone successfully done this? Any guidance would be greatly appreciated.
I have an option in seats and tickets. I have a bar chart and can find order dates prior to performance. This will show how many tickets were sold with x days left to the performance. Is this what you were looking for?
I am just trying to show the number of days left from the report date to the show date, so I don't think that option will work for me:
Looking for the same thing, i had just tried DDiff(now([Days in Date]), [Days in Production Season Opening Date]) looking at the production season opposed to individual performancehow did you get the column of "days to show"
I used this formula to get the Days To Show column:
I think you'll just need to add MIN() to your formula to get what you need. I used Order Days in Date and Performance Days in Date, but it seems like you should be able to use Order Days in Date and Days in Production Season Opening Date as well.