I have a column [Dispatch Key]. It is a type - โrefโ (to another Table). I only want to show the rows that have column[Complete]= โyesโ (in that referenced table).
I tried a show if expression, but this didnโt work:
[Complete] = โyesโ
I also tried this expression, but it didnt work either:
ISNOTBLANK([Complete])
Solved! Go to Solution.
Oh, you donโt need a slice (you can delete it), you need a Suggested values expression for the Dispatch Key column:
FILTER(
"another Table",
([Complete] = "yes")
)
replacing another Table
with the name of the table referenced by the Dispatch Key column.
Ok. The slice was where its at! Thanks again Steve!
Ok. I spoke too soon. I am using the Row Filter condition - but for some reason i am seeing rows i shoudlnโt be seeing.
In my table i have a row with column - [Dispatch Ticket] = 8906. This row does NOT have โYesโ under the column [Complete].
Here is the expression i used:
In order for the slice to have any effect, you have to put views on top of it. Create a new view, but instead of choosing Rating Table as the For this data value, choose your new slice. Then visit that view in your app.
I did, but i see the that same row in the app. Shouldnโt it be hidden?
Oh, you donโt need a slice (you can delete it), you need a Suggested values expression for the Dispatch Key column:
FILTER(
"another Table",
([Complete] = "yes")
)
replacing another Table
with the name of the table referenced by the Dispatch Key column.
ok. That for sure worked!
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |