I currently have the following Slice constructed:
OR([_THISROW] = ANY(TOP(FILTER(BRADYcore@HOME,AND(ISNOTBLANK([Category]),([Category] = "ARMS"))),1)), [_THISROW] = ANY(TOP(FILTER(BRADYcore@HOME,AND(ISNOTBLANK([Category]),([Category] = "BACK"))),1)))
And, when I click the “Test” button for the expression, it produces one item of Category ARMS and one item of Category BACK.
But, when I use it as the dataset for a View, the View displays all items in the dataset, as if I hadn’t done anything.
The goal is to produce one random value of Category ARMS and one random value of Category BACK, and have that display in a particular View (using this Slice).
Please help! I’m trying to learn AppSheet but there is a learning curve, compared to my non-AppSheet SQL experience.