Set Analysis Help Please...

[samvile18]

Afternoon everyone,

Is this even possible what I'm attempting to do?! 

I'm trying to use this the following set analysis to calculate a percentage of users that login via their app to our services:

=Sum({<
resultsview = {'Logins'},
resultschannel = {'App'}
>} num_uniques)
/
Sum({<
resultsview = {'Logins'},
resultschannel = {'App', 'Web'}
>} num_uniques)

The above works but I also have resultschannel on the sheet as a filter, when a user selects it, the chart blanks. Can I ignore just the selections in resultschannel but also include the field within the calculation?

Any help is appreciated as I'm tearing my hair out. 

[robert_mika]

Try to add:

resultschannel =

=Sum({<resultsview = {'Logins'},
resultschannel = {'App'},[resultschannel] =>} num_uniques)
/
Sum({<resultsview = {'Logins'},resultschannel = {'App', 'Web'},
[resultschannel] =>} num_uniques)

[Or]

Are 'App' and 'Web' the only values in the field resultschannel? What value(s) is the user selecting when it blanks? 

Generally speaking, this set analysis should ignore the selections made in the resultschannel field. However, the selection in resultschannel may be impacting other fields which then impacts the ability to calculate num_uniques, so this may be related to that (couldn't say without knowing what the schema is and how the values interact). 

[lennart_mo]

Another thing to look out for is wether you use a calculated dimension for the filter. Is the dimension just the field or is there a formula?

If there is a formula, try using the function CalcDim() on the whole expression. Now, when you make a selection, the selection should truly be made in the field resultschannel.