I've created a pie chart to show percentage of attendance for Members v. Non-Members, based off Productions in Tessitura. Non-Members are showing as [none]. Is there a way to change the label for data within a (I don't know the correct term here) category...item? ([none] below should be Non-Members in the example below.) I know how to change the name of the category, but not the data within the category.
Hi Josephina,
To work around the (none) category I recommend removing Membership Organization from Categories and instead create a Value per membership organization using Filtered Values. As you create each Value, rename it to the name of the Membership Organization, except for when you create the (none) category, rename it to Non-Members.
Thank you! I thought this would be the solution, but I'm having a hard time figuring out the formula. I have successfully created filtered values (in a separate widget) to break out the values in the Non-Member segment by production, using the formula "(sum([Ticket Count]),[Production1])". However, when I try to use a similar formula for Membership Organizations so I can filter the values, I get an error message:
I'm sure I'm overlooking something obvious, but I can't quite figure it out.
I think you have to move the 'SUM' part within the parentheses.
Geez, it was something obvious and simple and I indeed overlooked it! Thank you so much!