Limit rows in table visual

Question & Answer
,
1

i want to make a table view of my data and want to download as CSV. i ahave applied sorting based on a feild
i want to apply limit on number of rows
i know it is not possible to limit number of rows user download but can there be a way that we only display top 50 % data ?

2

Hi @shivam1,
What fields are you using in your table? Depending on how the data is aggregated, you can certainly limit the returned values in that way.
One way to do this would be to create a denseRank calculation for your row values aggregated by whatever filed you’re using as your value in the table. That way, it ranks your rows based on that field.
Then use that calculated field as a filter on your visual to only show the top x results.

You can also try out the percentile function

Let me know if you have any additional questions

3

Thanks … Feilds in my table would be Product ID , sales and the table would be sorted by sales in decending order. i want some top x percent data

4

Hi @shivam1,
I put together 2 different options that you could try out for your scenario depending on how you want to limit the results. You can view the two options in the attached Arena view. Let me know if you have any additional questions:
Limit rows in table visual

5

Hi @shivam1,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

6

Hi @shivam1,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!