A new appsheet user. I have successfully created slices with row filters using enum type column. The row filter was like ANY(tablename1[column1])=[column a]. In the successful cases column1 was a enum. I canโt write a row filter for a column that is enumlist (multiple values). I understand ANY selects only 1value. So what row filter expression would work for an enumlist type column.
Solved! Go to Solution.
Great, I found the solution!
It was more simple than what I imagined.
Basically, the expression/ function that I used was:
= IN([Color], Filter[Color])
I just aware everyone to keep only one row in the โFilterโ Table:
Then you will be able to get the following result:
Thank you @Steve for clarifying where I was stuck in
@mvp
You can use
CONTAINS({"Your", "values", "here"},[EnumlistColumnName])
Thanks very much. Works great. I had not found the CONTAINS function.
Hi,
Itโs not clear for me this CONTAINS() function since the values in curly brackets {โYourโ, โvaluesโ, โhereโ} are not automated.
Iโm having the same problem as Dan, I achieved doing a slice row filter with Enum like this app sample:
When I change in Data >> Columns >> โFilterโ Table, the โColorโ column to Enumlist, the filter works (Iโm able to select โBlueโ and โRedโ at the same time), but the chart does NOT correspond to the selection.
Therefore, I believe itโs a problem in the Slices >> โFiltered Dataโ >> Row filter condition =
ANY(Filter[Color]) = [Color]
I tried putting the following Row filter condition instead, but it still doesnโt work:
CONTAINS(ANY(Filter[Color]) = [Color],[Color])
Hope someone can help me making it more automated instead of stating each of the desired values.
Thanks!
Iโve checked on AppSheet community and I still didnโt succeed to achieve this feature, Iโm sure it is an expression detail that Iโm not getting right.
Here is another trial with the following expression, but the bar chart is counting wrong:
CONTAINS(ANY(Filter[Color]), LIST([Color]))
Here is what I am trying to get it, but as you can see the expression is not automated, so if select only โBlueโ it will still count both colors on the chart
CONTAINS({โBlueโ, โRedโ},[Color])
Obs.: My โColorโ column in โFilterโ table, i.e. Filter[Color] is a EnumList, which is working fine and Iโm not using โInteractive modeโ on the dashboard View or a Ref (referenced column) because I guess is just a filter on the Slice Iโm current in (picture above).
Many thanks!
Hi @Steve,
I tried this:
IN(ANY(Filter[Color]), LIST([Color]))
or
IN(ANY(Filter[Color]), LIST(Data[Color]))
But it still doesnโt work correctly.
The expression ANY(Filter[Color]) keeps change dynamically as I select the buttons โRedโ and โBlueโ together, which is good because it automates the app, like this picture:
For instance, this expression looks to work correctly:
CONTAINS(ANY(Filter[Color]), LIST([Color]))
When I check on โTestโ it gives these results (=TRUE), but the chart does not sum correctly:
However, as I did in the previous comment, when I write:
CONTAINS({โBlueโ, โRedโ}, LIST([Color])) or CONTAINS({โBlueโ, โRedโ}, [Color])
the chart sums correctly both Blue and Red.
Isnโt that weird?
Did you look at the doc?
Great, I found the solution!
It was more simple than what I imagined.
Basically, the expression/ function that I used was:
= IN([Color], Filter[Color])
I just aware everyone to keep only one row in the โFilterโ Table:
Then you will be able to get the following result:
Thank you @Steve for clarifying where I was stuck in
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |