I have the task of comparing two years and the way I want to do it is to compare the top grossing event in one year to the top grossing event in the other year. My thought was to create two charts, rank the events by revenue and then compare them in a third chart, but while creating the third chart I realized I was out of my league. If I do it this way is it possible to bring the #1 grossing event from both years into the third chart and get a difference between them? I basically want to show the rank, event, total and then the difference between the #1 in the first year to the #1 in the second year and so on...
Is it possible to do this in one chart?
I've attached a simple example of what I've started with, but can't figure out how to get the comparison to work.
And this does a script based pre-aggregation and ranking.
Should have the best performance (and expressions are much more simple), but you are losing the ability to filter dynamically by making additional selections).
