Let’s say you are performing a calculation that requires a large number of rows in the query, but you only want to display a small subset of those rows in the visualization. You can do this by creating a table calculation that only returns Yes for the rows you want to see in the visualization, and then using Hiding No’s from Visualization for that table calculation.
For example, in order to only see the first 10 rows in my visualization, I can create a table calc like this:
row() <= 10
This will return Yes for the first 10 rows, and No for all the other rows. I can then select Hide No’s from Visualization from the gear dropdown for this table calc column like so:
Now I only see the first 10 rows in my visualization: