Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to display a calculated expression (it is a ratio of two fields in the data model)
by two dimensions: time and location
on a line or bar chart.
The first dimension, the horizontal axis is =WeekEnd(xDateTime)
The second dimension is location, e.g. a list of cities.
There are many locations, so filtering is necessary to be able to see the trend in particular arbitrary comparison cities.
The data goes back many years, so filtering is necessary to focus in on a specific timeframe.
If I simply "Show Total" for the location dimension, this is what I want...except that if I make a selection, the total is affected and will show the selection total, not the total for all locations.
How do I do this?
Say your current expression is sum(A)/sum(B). I think replace that with this?
if(dimensionality()=2,sum(A)/sum(B),sum({<Location>} A)/sum({<Location>} B))
perfect! I was imagining much more complicated ways to do this, did not know about the diminsionality function. Thanks