Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to create a dimension for a chart so that only filters in my specified alternate state (Overview) affect it.
Here is the dimension I am trying to use in my straight table:
=aggr(Only({Overview<User = $::User, Month = $::Month>}Activity_ID),Activity_ID)
However, nothing populates in the table. The alternate state is called "Overview" and I want only the "User" and "Month" filters to impact the chart.
I think you should be driving the selection impact of filters from the expressions instead of dimension.... what is the expression in your chart?
yeah I know, the problem is I have a lot of expressions (lots of columns in my straight table)
I was hoping there is a way to do this from the dimension formula. Is this possible?
As far as I know, you will need this set analysis in the expression to drive the results based on alternate state and User and Month from default state.
ok thank you