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
Hi Terry,
So long as the production is the first column, I think it should work to add others.
Hi Sara,
Yep, what Tom said. Rename the column simply a period (".") and then resize the Pivot Table column to be as narrow as possible so that you can't even really see the content of it. You can resize columns by clicking on the border of the column header and dragging...
For a Pivot? Can you change text color (without java)? ... I asked JJ about this at TLCC and i think that the best we came up with was making the fill black
Chris Wallingford said:You could explore changing the logic of the TX_ANALYTICS_DIVISION_ELEMENT for First Performance Name to prepend a sort code.
Is this the sorting solution that is working? If so, might someone let me know exactly how to do this please? Thank you!
BWG