I am trying to limit the number of plots in my Scatter plot based on a different limitation measure than the pre-suggested one.
So basically i have Dimension = A , y-axis shows = B and x-axis shows = C. The 1000 plots shown should be based on a ranking of the 1000 biggest records according to D.
Very thankful for any suggestions on how to solve this, please let me know if i can provide any additional information to specify my problem.
you could do an Aggr(Only([Field A] = {"=calc(fields) > 0"}Field A),FieldA) where your set analysis is creates the limitation. In its most simple form, show only Movies that are Scifi:
Aggr(Only({<Genre={'SciFi'}>}Movies),Movies)
in your example, you make a more complex set that includes a ranking.
