How can I allow end user to "see all" rows?

cynthial

Hi,

I would like to create a card that shows only 6 rows by default, but have the end user be able to choose to see all the rows (bascailly turning off the limited number of rows) without editing the card in the analyzer to see them. How do I do this?

Is there a filter I can set up to allow users to turn on or off the limited number of rows?

MarkSnodgrass

You could pull this off using variables as well as a window function to create a row count. To create a row count, create a beast mode like this:

SUM(SUM(1)) OVER(ORDER BY Start)

Change Start to whatever field you need to order by in your dataset.

Create a variable control. I would use a radio button control that says "Show All Rows" and have Yes and No as values.

Now create a beast mode that you will drag into your filters that checks to see whether it should limit the rows or not. It would look like this:

CASE when Show All Rows = 'No' THEN

CASE when SUM(SUM(1)) OVER(ORDER BY Start) <= 6 THEN 'Include'

ELSE 'Exclude'

END

ELSE

'Include'

END

Drag this beast mode into your filter and then filter to Include.

Now you can toggle with the variable control to show all rows or just the first 6.

MarkSnodgrass

You could pull this off using variables as well as a window function to create a row count. To create a row count, create a beast mode like this:

SUM(SUM(1)) OVER(ORDER BY Start)

Change Start to whatever field you need to order by in your dataset.

Create a variable control. I would use a radio button control that says "Show All Rows" and have Yes and No as values.

Now create a beast mode that you will drag into your filters that checks to see whether it should limit the rows or not. It would look like this:

CASE when Show All Rows = 'No' THEN

CASE when SUM(SUM(1)) OVER(ORDER BY Start) <= 6 THEN 'Include'

ELSE 'Exclude'

END

ELSE

'Include'

END

Drag this beast mode into your filter and then filter to Include.

Now you can toggle with the variable control to show all rows or just the first 6.