So I have a challenge where I'd like to calculate in Tessitura Analytics The % of folks who bought one performance also bought another.
In our case each day we sell general admission tickets to all who attend the museum. Some folks also choose to purchase a Planetarium Tickets. I'd like daily to be able to determine what percent of the General Admission folks (listed in a particular report) also chose to add on the other show. (Without doing something crazy like hand-editing the formulas for each value.
Has anyone worked out how to do these cross performance type comparisons? I'm sure that I'm going to have to get into the formula editor. (I know that stuff like this can be done in something like Power Pivot, although it can be challenging to bend one's mind around how to do these types of comparisons.)
Thoughts?
Let me know if you find a solution for this in Sisense! Currently, we're doing these kinds of "crossover" calculations outside of Tessitura, in R.
OK. I may not have a moment over the next few days. (I hope it can do things like this.) If anyone else has ideas please feel free to jump in.