limit # of rows for straight table export

[kmstephenson]

Hi All,

I'm hoping to limit the number of rows (100) an end user can export from a specific table at a time. I tried using dimension limits, showing only first 101 values with Show Others checked and Collapse Inner Dimensions checked. However, I am allowing interactive sort for my straight table so if a user sorts on anything other than MRN (the first dimension), it shows the first 100 MRNs for each value of the field sorted by instead of still showing only 100 total rows.... Any way around this to either show always first 100 MRN (and sort on this) or first 100 of the field sorted by?

[rwunderlich]

Instead of DImension LImits, use the Presentation -> Max Number = 100. That will show the first 100 based on whatever sort order the user choses.

-Rob

http://masterssummit.com

http://robwunderlich.com

[kmstephenson]

Hi Rob,

Thanks for the quick response! I did try this out when I was looking for a solution but it appears to me as if there is no easy way to get at the next 100 rows.... We would like them to have access to all of the data but be able to select "Next" or something like this to be able to view more data... Any ideas?

Thank you!

[Gabriel]

Hi,

I will try using Calcuation Condition on General tab of the chart.

click the ellipsis (...) then enter

= Dimension_Primary_Key <= 100

This will ensure nothing greater than 100 is displayed in the chart and exported.

NB:

Dimension_Primary_Key is the field name that identify each row in the table

[kmstephenson]

Hmmmm this doesn't appear to be subsetting the table at all- would this limit to 100 rows displayed but allow the user to make a selection to view the next 100 rows, and so forth?

[Gabriel]

No.

It will display 100 row.

What's your requirement?

[stigchel]

You can maybe use a class or rank function and put them in a listbox to select in sets of 100. I have attached an example for reference

[kmstephenson]

I want to display 100 at a time but allow the user to click a Next button (or something similar) to view the next 100.

[stigchel]

Have you seen my example up in the thread?

[kmstephenson]

This is awesome, thanks for sharing! It does look like you have to know how you want the data sorted though. I want to show the first 100 MRNs no matter how the data is sorted. I have ~8 columns in the straight table, so no matter how the table is sorted (user can double click a column to sort by it), I want to show the first 100 with an option to select "Next" to show the next 100....