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?
I found this section of the Sisense documentation for Sisense V7.1 on Measured Values.
I'm wondering if this is a possible solution to my challenge.
It's late here in Easter USA. So, I take a look at some other moment.
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.
I've given it a few attempts. I'm getting pretty flash at filtered values in Analytics but this is a little bit beyond that. It's the having count(distinct prod_season_no) >= 2 that I find difficult to translate from SQL.
I don't think this is a general dashboard or widget filter thing. I think that it's a formula thing and like "unfiltering" at the formula level so that you can "see" the other performance in every row of the data, regardless of the scope of this row of data. I've not worked on this since Tuesday when I wrote the question. It's sort of like having a CTE that just produces the general admission numbers for the day and then joining on the date of the performance. (Maybe, that's the way it would work in MS Power Pivot)