Skip to main content

Analytics

Tableau – Table Pagination

Close Up Pen On Paperwork And Woman Hand Calculate Finance.

Pagination is a great way to improve the user experience and minimize the footprints that tables occupy within Tableau dashboards. In cases, where we need to show multiple records or our tables are too long to display it in single view, pagination comes to rescue.

By implementing this technique, users will be able to “turn the page” to another set of rows. However, setting it in a way to make it dynamic can be tricky!!

Let’s dive in and unfold the leash!

Data:

Sample Superstore Data

Load Orders Data Source

Parameter:

We need to create a Parameter for “Page Size”:

Steps:

  1. Set Name to Page Size
  2. Set Data Type as Integer
  3. Set Current Value to 20
  4. Set Allowable Values to Range
  • Set Minimum to 5
  • Set Maximum to 20
  • Set Step Size to 5

Something like this:

Parameter - Page Size

Calculated Fields:

To keep a count on current Page Number:

INDEX

INDEX ()-1

 

Page Number

INT([Index]/ [Page Size]) +1

 

Worksheet:

We now build our Worksheet:

  • Change Mark Type to Text
  • Drag Order ID onto the Rows Shelf
  • Drag Order Date onto the Rows Shelf
    • Right Click on this pill, select Exact Date and convert to Discrete
  • Drag Customer Name onto Rows Shelf
  • Drag Customer ID onto Rows Shelf
  • Now double click on Sales, Quantity and Profit.

We now see the following:

WS - Measure Value & Measure Names

Now, we add pagination:

  • Drag Page Number onto the Rows Shelf
    • Right Click on this pill and convert to Discrete
    • Drag this pill on the Filters Shelf and select 1

Note: “Page Number” is renamed to “Page” using Edit Title

We now see the following:

Page Number Filter

Dashboard:

Now we move to our final step – Visualization.

Using proper Objects and Alignments we pull our worksheet onto the Tableau Dashboard.

Table Pagination

Voila!! We can control the Page Size using the parameter and select the Page Number using the filter in Tableau.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Apeksha Singh

Apeksha has 4+ years of experience in the Business Intelligence & Analytics domain. She is working with Perficient as Senior Tableau Developer. Apeksha is enthusiastic & eager to deep dive into Data Science.

More from this Author

Categories
Follow Us
TwitterLinkedinFacebookYoutubeInstagram