Question:
Has anyone worked out how to filter in sisense to see just the next performance in a series of performances? If so, I'd love to hear how you are filtering to just that performance
Background:
Here at LSC, we have an event every third Thursday of the month. We are working on sending a report to the producer of that event about the sales for the event. We are hoping to show just the next event in the series. We are sending the report via Sisense nightly. If we choose this month for a date filter that is good until the third Thursday but does not switch to the next event automatically. If in the latter portion of the month we choose next month. Things, once you get to the first-day things, don't shift to the current month.
Thoughts? Might some sort of ranking work? Can you build a conditional filter?
I'm now trying a filter for the next 30 days. That will be closer to what I want. However, what I really want is the day after the performance I want the final results for the performance that just happened. Then on last event date +1, I want to start to see the results for the coming event.
Still looking for a great solution so I don't have to manipulate the dashboard every so often.