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 utility or embedded in internet apps and portals.
Within the earlier put up 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.
Cover or present fields for authors
Beforehand, authors might solely conceal fields in tables. Now we’re extending this function to pivot tables as effectively. Authors can conceal rows, columns, and values from both the sphere wells or from the column or row discipline 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 possibility.
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, it’s possible you’ll wish to conceal fields in a pivot desk whose sole goal is to allow actions, like opening one other webpage and cross this hidden discipline as a parameter.
- Use hidden fields to outline a customized type order – You possibly can outline a customized type order on your pivot desk utilizing hidden fields, for instance, defining a selected order on your PNL studies.
- Show two tables facet by facet 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 facet by facet is to create butterfly tables the place values are displayed on either side of the dimension. It is a nice approach to evaluate two units of values. For instance, you’ll be able to evaluate the present month vs. a full yr of information.
Export hidden fields for authors and readers
Not solely can authors conceal fields, they will additionally management the flexibility for readers to export knowledge together with the hidden fields or with out them. When publishing the evaluation, authors have the brand new possibility Allow export of hidden fields on supported visuals. When you choose this feature, readers are in a position to embody 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 put up, we appeared on the new functionality of toggling row, column, and worth discipline visibility on tables and pivot tables. We additionally mentioned the varied use instances for hiding fields and the brand new exporting choices related to discipline visibility, which will be managed by authors. To study extra about desk and pivot desk formatting choices, discuss 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.
In regards to the writer
Bhupinder Chadha is a senior product supervisor for Amazon QuickSight targeted 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, answerable 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.