Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've created an expression in a filter pane. I did this because I wanted to use fields from across tables and this worked better than joining all tables and filtering via script since I have other sheets this isn't needed for and has caused other issues for.
I also have a count KPI on a record id field. I can see the expression (see below) works when I select either Y or N as the record id counts change. However, when I filter to only N and export I still get all records. I don't understand why and if there is a fix.
here's the expression I created:
=if([Origin Type]='ACQ-DELETE' and isnull([Number Of Gifts]),'Y','N')
Thank you,
brian
Hi Brian,
Are you exporting a filter pane or chart ?
You can create a master dimension and include in all charts and filterpane instead of writing separately.
thanks