Good afternoon,
Please take a look at the screenshot below. I want to make a bar chart out of the CYO package sizes that will count the # of constituents who have a 3-5 performance CYO, a 6-9 performace CYO, and so on. I've included a manual bar chart that I made from last season, but I was wondering if Analytics can do this automatically based on the pivot table data. Would this be a jump-to?
Thank you,
Ilana
You need to change the filters on the 4 different Filtered Values. In other words, you need to go into each of the four different formulas (3-5, 6-9, 10-12, 13+) and change the filters to this year's versions.
Thank you, Neil, I appreciate your response! I probably need a bit more explanation... and I also want to reiterate that the 22/23 season bar chart is an eample of a manual chart that I created in excel. I have yet to figure out how to visualize the pivot data from Analytics in Analytics.
Hi Ilana! I've used a sum and if statement to get a similar grouping looking at multi-buyers.
For instance:
sum( [Constituent ID], if ( count ( [Performance ID]) >= 10 and count( [Performance ID]) <=12, 1, null))
Then you could copy the formula and adjust the values to get your different groupings. I hope that helps!
~ Christine
Ilana, may I suggest you watch this video?Take Your Tessitura Analytics Skills to the Next Level (tessituranetwork.com)I think the video will help you. Especially, the filtered values part.
I was able to use Christine's formula idea to create this chart, which I think is accurate.
Since we only sell CYO packages in that specific MOS, I used that as my Category filter. Then used the formulas for the values.
Hope that helps! And thanks for the idea, I think this will be useful for me as well!!!
wowowowow you all are geniuses. Thank you SO much, it worked!!