知识库

How to limit the number of rows displayed


发布时间: 22 Dec 2023
上次修改日期: 25 Dec 2023

问题

How to create the Page Navigation using "Next Button" like a Report. How to split a long table into multiple pages and switch between them.
User-added image

User-added image

环境

  • Tableau Desktop

答案

1. Create a Parameter to control Page number as bellow.
User-added image

2. Create calculated fields as bellow.
[Rows per pages]
20
[INDEX]
INDEX()
[Page filter]
[INDEX] > (([Page Selector]-1)*[Rows per pages]) AND [INDEX] <= ([Page Selector]*[Rows per pages])

3. Place the [Page filter] on Filters shelf and select True. Then Show Parameter and use it to control the number of rows displayed.

4. (Optional) On the dashboard, show the parameter and change the settings as bellow. Then shrink the size until it reaches a suitable size as the Next button.
User-added image
 
此文章是否已解决问题?