Hi all,
I'm putting together a calendar heatmap to show the most popular performances in terms of ticket sales - so far so good.
The issue I have is that some days have multiple performances and the calculation is simply creating a sum of all performances on that day, rather than giving me an option to somehow divide the day up. I appreciate this is quite a niche request, but is there any way to split a date in half (or into multiple portions) to reflect each performance on that day?
Many thanks in advance!
Best wishes,
Joe
Hi Joe,
Not within a single calendar widget. The most granular that widget gets is daily results. So, the most popular dates in terms of ticket sales.
You could have multiple calendar widgets, each focusing on a distinct "time slot" assuming there aren't multiple matinee or evening performances.
You could try a treemap widget, which will split out the unique performances if you like, but the dates won't be in order. That widget forces a sort based on the value such that the most popular date will be in the lower right.
You could try a polar chart with the performance codes in the break by. This will stack the perf codes and the most popular dates will pop out. Then you can mouse over to see the individual performance values.
Or try a pivot table with date on rows and performance hour on columns, and then some conditional coloring.
Here's something to get you started... PerformanceCalendarHeatmaps.dash
This is so helpful, thank you Chris! I'll take a look.