Wednesday, September 28, 2022
HomeBig DataNew row and column interactivity choices for tables and pivot tables in...

New row and column interactivity choices for tables and pivot tables in Amazon QuickSight – Half 2

Amazon QuickSight is a fully-managed, cloud-native enterprise intelligence (BI) service that makes it straightforward to create and ship insights to everybody in your group and even along with your prospects and companions. You can also make your knowledge come to life with wealthy interactive charts and create stunning dashboards to share with hundreds of customers, both straight inside a QuickSight software or embedded in internet apps and portals.

Within the earlier publish on this two-part sequence, we mentioned drag handlers to change top and width for rows, columns, and desk headers. Now, let’s take a look at a number of the new interactivity choices for rows and columns for tables and pivot tables.

Conceal or present fields for authors

Beforehand, authors may solely disguise fields in tables. Now we’re extending this function to pivot tables as nicely. Authors can disguise rows, columns, and values from both the sector wells or from the column or row area headers in pivot tables. For simpler identification, hidden fields are indicated with a cross eye icon; you’ll be able to revert them again to seen utilizing the Present all hidden fields choice.

Let’s take a look at a number of the use instances the place this may very well be useful:

  • Outline actions on a pivot desk and conceal fields to avoid wasting actual property – Typically, chances are you’ll need to disguise fields in a pivot desk whose sole goal is to allow actions, like opening one other webpage and move this hidden area as a parameter.
  • Use hidden fields to outline a customized type order – You may outline a customized type order on your pivot desk utilizing hidden fields, for instance, defining a selected order on your PNL experiences.
  • Show two tables aspect by aspect as a single visible – Within the following instance, we present gross sales by nation, the place desk 1 shows the final 4 weeks of information and desk 2 shows month-to-month knowledge from the final 4 weeks.
  • Create butterfly tables – One other variation of displaying tables aspect by aspect is to create butterfly tables the place values are displayed on each side of the dimension. This can be a nice technique to examine two units of values. For instance, you’ll be able to examine the present month vs. a full yr of information.

Export hidden fields for authors and readers

Not solely can authors disguise fields, they’ll additionally management the power for readers to export knowledge together with the hidden fields or with out them. When publishing the evaluation, authors have the brand new choice Allow export of hidden fields on supported visuals. When you choose this selection, readers are capable of embrace hidden fields when exporting their knowledge. The default setting is to maintain this disabled and solely enable readers to export seen knowledge.

Based mostly on the totally different situations, the next choices present up for exporting knowledge to CSV and Excel from tables and pivot tables.


On this publish, we regarded on the new functionality of toggling row, column, and worth area visibility on tables and pivot tables. We additionally mentioned the assorted use instances for hiding fields and the brand new exporting choices related to area visibility, which could be managed by authors. To be taught extra about desk and pivot desk formatting choices, confer with Formatting tables and pivot tables in Amazon QuickSight.

Check out the brand new function and share your suggestions and questions within the feedback part beneath.

Concerning the creator

Bhupinder Chadha is a senior product supervisor for Amazon QuickSight centered on visualization and entrance finish experiences. He’s enthusiastic about BI, knowledge visualization and low-code/no-code experiences. Previous to QuickSight he was the lead product supervisor for Inforiver, liable for constructing a enterprise BI product from floor up. Bhupinder began his profession in presales, adopted by a small gig in consulting after which PM for xViz, an add on visualization product.



Please enter your comment!
Please enter your name here

Most Popular