Forum Discussion
Need help with google analytics data
Hi everyone,
I am creating a dahsboard with Google Analytics data.
I have several metrics, 2 of them are Users and Screened-out (people who have been screened out from the site).
I am trying to create graphs where I can see data of users who haven't been screened out.
I tried to use a filter "screened out=0" but it gave me wrong data.
Any tricks?
Thanks!
Hello @raphaelle95 ,
Not very clearly...... You seem to set a flag (1 and 0) for the screen user, don't you?
filterrd = IF ( MAX ( 'FilterTable'[Screened-out ] ) = "Yes", 1, 0 )Have I answered your question? Please mark my answer as a solution. Thanks a lot.
If not, load some insensitive data samples and expected output.
Best regards
Eyelyn Qin
2 Replies
Hello @raphaelle95 ,
Not very clearly...... You seem to set a flag (1 and 0) for the screen user, don't you?
filterrd = IF ( MAX ( 'FilterTable'[Screened-out ] ) = "Yes", 1, 0 )Have I answered your question? Please mark my answer as a solution. Thanks a lot.
If not, load some insensitive data samples and expected output.
Best regards
Eyelyn Qin
Anonymous
Calculate(Total Count, filter(all(Tablename),status = "Screened Out")
