Amazon QuickSight is a fully-managed, cloud-native enterprise intelligence (BI) service that makes it simple to create and ship insights to everybody in your group and even together with your prospects and companions. You can also make your information come to life with wealthy interactive charts and create stunning dashboards to share with 1000’s of customers, both immediately inside a QuickSight utility or embedded in internet apps and portals.
Within the earlier submit on this two-part collection, we mentioned drag handlers to change peak and width for rows, columns, and desk headers. Now, let’s take a look at among the new interactivity choices for rows and columns for tables and pivot tables.
Cover or present fields for authors
Beforehand, authors might solely conceal fields in tables. Now we’re extending this characteristic to pivot tables as properly. Authors can conceal rows, columns, and values from both the sector wells or from the column or row subject 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 among the use instances the place this could possibly be useful:
- Outline actions on a pivot desk and conceal fields to avoid wasting actual property – Generally, it’s possible you’ll need to conceal fields in a pivot desk whose sole goal is to allow actions, like opening one other webpage and cross this hidden subject as a parameter.
- Use hidden fields to outline a customized type order – You’ll be able to outline a customized type order in your pivot desk utilizing hidden fields, for instance, defining a particular order in your PNL reviews.
- 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 information 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 either side of the dimension. This can be a nice technique to evaluate two units of values. For instance, you’ll be able to evaluate the present month vs. a full 12 months of information.
Export hidden fields for authors and readers
Not solely can authors conceal fields, they will additionally management the power for readers to export information 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 in a position to embrace hidden fields when exporting their information. The default setting is to maintain this disabled and solely enable readers to export seen information.
Primarily based on the completely different eventualities, the next choices present up for exporting information to CSV and Excel from tables and pivot tables.
On this submit, we seemed on the new functionality of toggling row, column, and worth subject visibility on tables and pivot tables. We additionally mentioned the varied use instances for hiding fields and the brand new exporting choices related to subject 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 characteristic and share your suggestions and questions within the feedback part under.
Concerning the writer
Bhupinder Chadha is a senior product supervisor for Amazon QuickSight targeted on visualization and entrance finish experiences. He’s keen about BI, information visualization and low-code/no-code experiences. Previous to QuickSight he was the lead product supervisor for Inforiver, accountable 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.