I created a simple dashboard looking at the count of first time buyers with a pivot table count widget and a bar chart widget for the current season and previous three seasons. The widgets default to sort by performance name alphabetically, but I'd prefer the list to be in order by when the performance occurred. This would make it easier to visually look across different seasons for shows that happen at similar times of the year.
For example, this year lists Beauty and the Beast (happening in Feb.) prior to Nutcracker when (happening in Dec.). Using the month as a second category starts to help, unless there is a case where a show occurs across two months, and then I end up with two rows for the same production.
I brought this up during Analytic Coffee today and others have had the same question - so we're posting to the forum for any advice!
My dashboard's .dash file is attached if anyone wants to use it as a base to try options.
PBTFirstTimeBuyers.dash
I'm trying to do the same thing with sorting production seasons by their performance month.