Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi gurus,
I have a group of dataset like this
data | Attributes | Flag |
a | Red | yes |
b | Blue | no |
c | Purple | yes |
d | colorful | no |
e | colorful | no |
f | colorful | yes |
g | White | no |
if I filter out Flag yes, it returns me data with Red, Purple and Colorful.
data | Attributes | Flag |
a | Red | yes |
c | Purple | yes |
f | colorful | yes |
is there a way, at filter panel for either Attributes or Flag , to achieve a conditional filter to only have Red and Purple without colorful.
I am thinking an expression like " if Flg = Yes, only attributes =Purple and Red"
any other ways to achieve this is also welcome.
much appreciated.
Are you looking for something like:
aggr(Only({$<Flg={'Yes'},Attributes={'Red','Purple'}>} Attributes), Attributes)
or, to exclude 'colorful' instead of including 'Red' and 'Purple, use:
aggr(Only({$<Flg={'Yes'},Attributes-={'colorful'}>} Attributes), Attributes)
ummm I tried this .but the panel filter of attributes turn to be only red , purple.
By default, I want to have that attributes panel filter to have all the data ( all colors )
I guess if I have to recreate a demission particularly for yes Flag + Purple +Red ?