Document History: What's New in the Amazon QuickSight User Guide - Amazon QuickSight
Previous Updates

Document History: What's New in the Amazon QuickSight User Guide

This page describes changes to the Amazon QuickSight User Guide and Amazon QuickSight console changes that include a documentation update. For notifications about documentation changes, subscribe to the RSS feed using the icon near the top of this page.

New Amazon QuickSight releases appear in different AWS Regions over a period of time, beginning with the first Region on the initial release date. Documentation is released in coordination with this process. If you have questions, contact AWS Support or your technical account manager.

To find out about changes to the Amazon QuickSight service, see Recent Announcements for Analytics – Amazon QuickSight or subscribe to the Amazon QuickSight newsletter. This monthly development-team email covers features, tips, customer stories, and more.

Note

The following table describes important changes in each Amazon QuickSight User Guide release since March 4, 2019.

In the Kindle guide version, you can find the last change date above the table of contents. On the Kindle website, the original publication date is unchanged.

Change Description Date

New Region: South America (São Paulo)

Amazon QuickSight is now available in South America (São Paulo) (sa-east-1). For more information, see AWS Regions, Websites, IP Address Ranges, and Endpoints.

December 23, 2020

New Region: Canada (central)

Amazon QuickSight is now available in Canada (Central) (ca-central-1). For more information, see AWS Regions, Websites, IP Address Ranges, and Endpoints.

December 23, 2020

Define an action to open a different sheet

QuickSight now supports navigation actions to enable you to open a different sheet with the included parameter values. For more information, see Using Custom Actions for Filtering and Navigating.

December 21, 2020

Data Source Enhancement: Athena Federated Query

QuickSight now supports connecting to Athena Federated Query. For more information, see Creating a Dataset Using Amazon Athena Data.

December 21, 2020

New list items sheet control type

Amazon QuickSight now supports single and multi-select list control on dashboards. For more information, see Parameter Controls.

December 18, 2020

New formatting options for tables

In Amazon QuickSight, you can now reorder columns in table charts. For more information, see Using Tables as Visuals.

December 17, 2020

Row-level security (RLS) now supports GRANT option only

To streamline and simplify RLS setup, Amazon QuickSight no longer supports using RLS in deny-access mode. To create a new RLS configurations, use the explicit grant-access model. For more information, see Joining Data.

December 6, 2020

New percentile functions

Amazon QuickSight now supports variations on percentile calculations, including aggregate functions percentileCont and percentileDisc and OVER functions percentileContOver and percentileDiscOver. You can use all of these functions in the calculations editor in analysis mode. For more information, see Functions by Category.

December 6, 2020

Dynamic queries, plus dataset editor improvements

Amazon QuickSight now enables you to improve performance for visuals based on direct queries by specifying unique keys for joined tables. There are also multiple interface improvements, such as settings for optional autopreviews, zoom in and out of data diagrams, join recommendations, and more. For more information, see Joining Data.

December 6, 2020

Developer Portal for Embedding

The QuickSight Dev Portal helps you learn how to use embedding by example in your web site or application. For more information, see Using the Dev Portal.

November 30, 2020

New data source: Amazon Elasticsearch

Amazon QuickSight now supports connecting to Amazon Elasticsearch. For more information, see Using Amazon Elasticsearch with Amazon QuickSight.

November 25, 2020

Format metrics on pie charts

Amazon QuickSight now supports formatting metrics on pie charts to display values, percentages, or both. For more information, see Customizing Data Labels.

November 25, 2020

New formatting options for tables

In Amazon QuickSight, you can now vertically align and wrap the text for headers in table charts. For more information, see Using Tables as Visuals.

November 24, 2020

New chart type: Box Plots

Amazon QuickSight now supports using box plots so you can visualize how your data is distributed across an axis or over time. For more information, see Box Plots.

November 24, 2020

Filled Maps

Amazon QuickSight now supports filled maps so you can visualize your data over a geographical area. For more information, see Filled Maps.

November 24, 2020

Favorite folders

In Amazon QuickSight, you can now favorite your folders for easy access. For more information, see Organizing Assets into Folders.

November 24, 2020

Change in Display Limits

For parameter controls and filters, Amazon QuickSight now displays up to 1,000 sample values. When you have more than that, you use the search box to locate a value. For more information, see Using a Control with a Parameter.

November 16, 2020

Null rendering

Amazon QuickSight now allows null values to be updated to a custom string. For more information, see Changing a Field Format.

November 9, 2020

New chart type: Waterfall charts

Amazon QuickSight now supports using waterfall charts so you can view your data sequentially. For more information, see Waterfall Charts.

November 9, 2020

Embedding for everyone

Amazon QuickSight Enterprise edition now supports embedding for everyone. When you purchase session packs with capacity pricing, you can enable visitors to use embedded dashboards without registering them as QuickSight users. For more information, see Embedded Analytics.

November 9, 2020

Column-level security

Amazon QuickSight now supports using column-level security to restrict access to a dataset. For more information, see Using Column-Level Security.

November 9, 2020

Service provider initiated federation

Amazon QuickSight Enterprise edition now supports service provider initiated federation, so you can sign on directly to QuickSight using your SSO login and password. For more information, see Setting Up Service Provider–Initiated Federation with Amazon QuickSight Enterprise Edition.

October 30, 2020

New chart type: Funnel charts

Amazon QuickSight now supports using funnel charts so you can display your data in a linear process. For more information, see Funnel Charts.

October 29, 2020

Custom sorting

Amazon QuickSight now enables you to apply sort options on fields outside the field wells. This feature is available for all charts that support sorting. For more information, see Describing Data.

October 29, 2020

New Region: AWS GovCloud (US-West)

Amazon QuickSight is now available in AWS GovCloud (US-West) (gov-west-1). For more information, see Amazon QuickSight - AWS GovCloud (US).

October 28, 2020

New data source: Oracle

Amazon QuickSight now supports connecting to Oracle. For more information, see Supported Data Sources.

October 23, 2020

Filter across datasets

In Amazon QuickSight, you can now create filters that apply to multiple datasets in an analysis. For more information, see Filtering Data.

October 23, 2020

Add field descriptions to datasets

Amazon QuickSight now enables you to add column or field descriptions to datasets. This metadata is visible in both datasets and analyses, helping you make your data self-explanatory. For more information, see Describing Data.

October 23, 2020

Filter controls on analysis sheets

Amazon QuickSight now offers a filter control that you can add to your analysis with a single click. You can put filters beside dashboard visuals and resize them to fit. For more information, see Using Filter Controls.

October 5, 2020

New data source: Amazon Timestream

Amazon QuickSight now supports Amazon Timestream as a data source. For more information, see Using Amazon Timestream Data with QuickSight.

October 1, 2020

Export to Excel

Amazon QuickSight now supports exporting data from pivot tables and table charts to Microsoft Excel (.xslx) format. For more information, see Exporting Data.

September 14, 2020

Duplicate sheets

Amazon QuickSight now supports duplicating sheets. For more information, see Working with Multiple Sheets in an Amazon QuickSight Analysis.

September 14, 2020

Customize labels of totals and subtotals

In Amazon QuickSight, you can now add custom text to display beside totals and subtotals for pivot tables and table charts. For more information, see Displaying Totals and Subtotals.

September 14, 2020

Skipped row details

When you import data into Amazon QuickSight, you now get better error messages and row-by-row information on what caused rows to be skipped during ingestion into SPICE. For more information, see Troubleshooting Skipped Rows.

September 12, 2020

New configuration option for multivalue lists

Amazon QuickSight now supports a configuration option for multivalue lists to start with no values selected. For more information, see Setting Up Parameters in Amazon QuickSight.

September 11, 2020

Reference lines

Amazon QuickSight now supports using reference lines in bar, line, and combo charts. For more information, see Reference Lines.

September 3, 2020

New table calculations

Amazon QuickSight now supports using window functions firstValue and lastValue in analyses. For more information, see Table Calculations.

August 25, 2020

Multivalue default parameters

Amazon QuickSight now supports dynamic default values for multi-valued parameters. For more information, see Creating Parameter Defaults in Amazon QuickSight.

August 25, 2020

Last active status for users

Amazon QuickSight administrators can now see the last date and time that people accessed QuickSight. For more information, see Viewing User Details.

August 25, 2020

Join SQL queries, tables, and files

Amazon QuickSight now supports using custom SQL queries in joins with other queries, tables, and files. For more information, see Joining Data.

August 25, 2020

Calculated expressions editor

The enhanced editor adds ease-of-use features to help you more easily create calculated expressions in Amazon QuickSight. With the new full-screen editor, you can add functions and values directly from the menu. For more information, see Adding a Calculated Field to an Analysis.

August 25, 2020

Personal and shared folders

Amazon QuickSight Enterprise edition now offers personal and shared folders to make it easier to discover, organize, share, and explore your available assets. For more information, see Organizing Amazon QuickSight Assets into Folders.

August 5, 2020

Embed the Amazon QuickSight console

In Amazon QuickSight Enterprise edition, you can now provide the full dashboard authoring experience of the QuickSight console in your own custom-branded authoring portal. For more information, see Embedding the Amazon QuickSight Console.

July 23, 2020

Datasets with 2,000 columns

Amazon QuickSight now supports datasets that have up to 2,000 columns. For more information, see Data Source Limits.

July 23, 2020

Customized permissions

In Amazon QuickSight Enterprise edition, you can now create custom roles to restrict a person from using specific functionality in the Amazon QuickSight console, for example to control who can manage data sources and datasets or who can manage or subscribe to email reports. For more information, see Customizing Access to the Amazon QuickSight Console.

July 23, 2020

Customize the console

In Amazon QuickSight Enterprise edition, you can now choose whether to show or hide QuickSight startup samples and videos. You can also create and specify a default theme to add branding to your experience of the QuickSight console. For more information, see Customizing the Amazon QuickSight Console.

July 23, 2020

Amazon QuickSight support for multitenancy

In Enterprise edition, QuickSight now offers an additional layer of security to support multitenancy. By creating users and groups in a QuickSight namespace, you can isolate them from users and groups in other namespaces. For more information, see Supporting Multitenancy with Isolated Namespaces.

July 23, 2020

Larger SPICE datasets

Amazon QuickSight Enterprise edition now supports SPICE datasets with up to 250 million (250,000,000) rows or 500 GB. For more information, see Data Source Limits.

July 9, 2020

Display width settings

In Amazon QuickSight, you can now choose between responsive and fixed layouts for your analyses and dashboards. You can also temporarily change your current view from the menu bar. For more information, see Display Settings.

July 9, 2020

Data refresh notifications

Amazon QuickSight now supports sending email to notify SPICE dataset owners when data refresh fails. For more information, see Refreshing Data.

July 9, 2020

Color settings for heat maps and tree maps

You can now customize gradient colors for your heat maps and tree maps in Amazon QuickSight. For more information, see Changing Colors on Heat Maps and Tree Maps.

July 9, 2020

Font choice

You can now customize your theme with a font. Choose from a selection of fonts supported by Amazon QuickSight. For more information, see Using Themes in Amazon QuickSight.

July 8, 2020

AWS Lake Formation

If you use Amazon QuickSight Enterprise edition to query Amazon Athena, you can simplify data access management by using AWS Lake Formation to control permissions to Athena. For more information, see Authorizing Connections through AWS Lake Formation.

June 29, 2020

New chart type

Amazon QuickSight now supports using histograms so you can display the distribution of values in your data. For more information, see Histogram charts.

June 12, 2020

Gauge chart update

You can now add conditional formatting to gauge charts in Amazon QuickSight. For more information, see Adding Conditional Formatting to Visuals.

June 12, 2020

Five new languages

Amazon QuickSight now supports Danish, Dutch, Finnish, Norwegian, and Swedish. These languages expand upon the existing 15 languages already available in Amazon QuickSight. For more information, see Choosing a Language in Amazon QuickSight.

June 12, 2020

New Region: Mumbai

Amazon QuickSight is now available in Asia Pacific (Mumbai) (ap-south-1). For more information, see AWS Regions, Websites, IP Address Ranges, and Endpoints.

June 3, 2020

New SQL editor

Amazon QuickSight enhanced the SQL editor that you use to create datasets from SQL queries. The new SQL editor supports syntax highlighting, basic autocomplete, autoindent, and line numbering. Also, you can use the new schema explorer to interactively explore schemas, tables, fields, and data types. For more information, see Using a SQL Query.

May 20, 2020

SageMaker integration now generally available

The integration of SageMaker with Amazon QuickSight launched in preview just before AWS re:Invent 2019. Now, this feature is generally available in all AWS Regions that are supported by QuickSight. Amazon QuickSight and SageMaker together makes it faster, easier, and more cost-effective for customers to make use of their machine learning models for visualization and predictions. For more information, see Amazon QuickSight Integration with SageMaker.

May 19, 2020

Update to Presto data sources

You can now use nonauthenticated private Presto as a data source. For more information, see Creating a Data Source Using Presto.

May 18, 2020

Rewrite of Amazon QuickSight VPC connection section

Based on your feedback, we completely rewrote this documentation to better explain using Amazon VPC with Amazon QuickSight. It includes examples and AWS CLI commands to help you establish the path from Amazon QuickSight to your data source, even if you're using on-premises sources. For more information, see Amazon QuickSight VPC Connections.

May 18, 2020

Use logarithmic scale with Amazon QuickSight

You can now format visuals using log scale. For more information, see Changing the Visual Scale.

May 1, 2020

Severity levels for Amazon QuickSight anomaly detection insights

You can now choose the level of severity for anomalies that display in your insight widgets. For more information, see Using Anomaly Detection.

April 17, 2020

Improvements to visual controls in Amazon QuickSight

The on-visual menu can now float at the upper-right corner of the visual, moving inside or outside the border of the visual. Plus, you can make your visuals smaller and have more of them, as many as 36 across. For smaller visuals, the new visual controls have more viewing area for charts and insights. To see the new menu, choose one of your visuals. For more information, see Working with Visuals.

April 17, 2020

Amazon QuickSight adds a new visual type

The new visual type, stacked area line charts, is similar to area charts except that the stacked values indicate the relationship that each value contributes to the whole. Using stacked area charts, you can display cumulative totals over time while displaying the breakdown by the chosen category. For more information, see Line charts.

April 17, 2020

Amazon QuickSight activates legends by adding menus for quick feature access

Amazon QuickSight now supports clicking on legend items to quickly access features like filtering, drilling, chart colors, and custom actions for filtering and URLs. For more information, see Focusing on Visual Elements and Custom Actions in QuickSight.

April 17, 2020

Amazon QuickSight adds cascading filters

You can now create cascading filters by adding them to custom actions in your analyses and dashboards. Each custom filter action can target one or more visuals in the same sheet, creating a cascading filter effect. For more information, see Custom Actions in QuickSight.

April 2, 2020

Modulo operation available in Amazon QuickSight

You can now use modulo operation to find the remainder after dividing one number into another. For more information, see mod.

March 8, 2020

Images in Amazon QuickSight narratives

You can now insert images from URLs to be rendered as part of a narrative. Images can be resized, conditionally shown within an IF block, and also hyperlinked with the URL feature. For more information, see Expression Editor Screen and Menus.

March 8, 2020

Amazon QuickSight adds minimum and maximum dates

You can now use minimum and maximum date aggregations in tables and pivot tables. For more information, see max and min.

March 8, 2020

Now you can customize minimum delta values to enhance Amazon QuickSight ML-powered anomaly detection

Now you can control the minimum delta value that Amazon QuickSight uses to detect anomalies (also known as outliers). You can change this setting when you are configuring or exploring anomalies. For more information, see Detecting Outliers with ML-Powered Anomaly Detection.

February 4, 2020

Improvements in the Amazon QuickSight narrative expression editor

Amazon QuickSight now provides a much more spacious interface for editing narrative expressions. The interface now has instant feedback in a preview of your evaluated narrative before you save any changes. Plus, narratives now support both static and dynamic URLs in your custom narratives for links to searches, apps, other dashboards, other sheets in the same dashboard, and more. For more information, see Using Autonarratives.

February 4, 2020

SageMaker integration now available in more AWS Regions

The public preview for integrating SageMaker with Amazon QuickSight is now available in all of the AWS Regions that are supported by QuickSight. For more information, see Amazon QuickSight Integration with SageMaker.

January 10, 2020

Private VPC support for Presto in Amazon QuickSight

Now Presto can use a VPC connection. For more information, see Supported Data Sources for VPC.

December 10, 2019

New mathematical functions in Amazon QuickSight

Amazon QuickSight now supports functions for base 10 logarithms (log), natural logarithm (ln), absolute value (abs), square root (sqrt), and base of natural log e raised to the power of (exp). For more information, see Functions and Operators.

December 10, 2019

New LAA functions in Amazon QuickSight

Now you can use rank, denseRank, and percentileRank for level-aware aggregations. For more information, see Using Level-Aware Aggregations.

December 10, 2019

Amazon QuickSight now enables you to choose an Amazon Athena workgroup

By choosing an Athena workgroup, you can better manage your Athena datasets. Using this option, you can also allocate Athena costs to the workgroup that QuickSight is using, for better cost reporting. For more information, see Creating a Dataset Using Amazon Athena.

December 10, 2019

Integrate SageMaker ML models into your Amazon QuickSight analyses and dashboards

In this public preview, Amazon QuickSight launches the ability to integrate machine learning (ML) models created and trained in SageMaker. This new feature makes it easier to augment your business data with ML predictions. Add your data scientists' prebuilt inferences and predictions to your analysts' dashboards, and let the collaboration and decision-making begin. For more information, see Amazon QuickSight Integration with SageMaker.

November 26, 2019

New formatting options for visuals in Amazon QuickSight

Amazon QuickSight launches more formatting for visuals and visuals titles, including font sizes from extra small to extra large. In key performance indicators (KPIs), you can set font sizes for primary and comparison values. In pivot tables and tables, you can see font sizes for table headers, cells, totals, and subtotals. Now your visuals render better even when smaller and with less padding between charts. For combo charts, you can now synchronize the Y-axes for both bars and lines into a single axis. For more information, see Formatting a Visual.

November 23, 2019

New Amazon QuickSight API operations

Amazon QuickSight launches new API operations to programmatically manage your data, dashboards, and fine-grained access control capabilities linked with AWS Identity and Access Management (IAM). With new data API operations, you can create, update, and delete Amazon QuickSight data sources and datasets programmatically. You can also manage data refreshes on your SPICE data sets with API operations. Amazon QuickSight also introduces templates, which store the visual configuration and data schemas required for a dashboard. You can transfer templates across accounts or use them to instantiate dashboards with the same visual presentation but different data. For more information, see the Amazon QuickSight API Reference.

November 22, 2019

Amazon QuickSight supports the now function in SPICE

For more information, see now.

November 22, 2019

Amazon QuickSight now supports seconds in SPICE

Seconds are now supported in SPICE data sets. Datetime fields are no longer truncated to minutes. Now you can use the SS option for the period parameter in date functions including addDateTime, dateDiff, extract, and truncDate. For more information, see Date Functions.

November 22, 2019

Amazon QuickSight now has themes

You can now create a collection of themes, and apply a theme to an analysis and all its dashboards. For more information, see Using Themes in Amazon QuickSight.

November 22, 2019

Amazon QuickSight now supports conditional formatting for tables, pivot tables, and key performance indicators (KPIs).

For tables and pivot tables, you can set multiple conditions for fields or supported aggregations, along with format options to apply to a target cell. For KPIs, you can format the primary value based on conditions that are applied to any dimension in the dataset. The conditional formatting options now supported are text color, background color, and placement of supported icons. You can use icons from the provided set, or you can use Unicode icons instead. For more information, see Adding Conditional Formatting to Visuals.

November 18, 2019

View history for SPICE ingestion on your Amazon QuickSight datasets

You can now view the ingestion history for SPICE datasets in Amazon QuickSight. See information like when the latest ingestion started, how long it took, and what its status is. For more information, see View SPICE Ingestion History.

November 7, 2019

Add your own functionality to visuals with Amazon QuickSight actions

Amazon QuickSight enables you to add to the basic functionality for visuals by creating your own custom actions for filtering or opening URLs. For more information, see Custom Actions in Amazon QuickSight.

November 7, 2019

Amazon QuickSight now supports dynamic sheet titles

You can now use parameters in sheet titles to make the context of a dashboard clearer to the reader. For more information, see Formatting a Visual.

November 6, 2019

Use Amazon QuickSight to join data from multiple data sources

Amazon QuickSight now supports creating datasets that join multiple data sources. For more information, see Joining Data.

November 5, 2019

Amazon QuickSight Mobile iOS update and a new Android app

Get access to insights from your data on the fly. Download the updated iOS app or the new Android app. You can browse, favorite, and interact with your dashboards and explore your data with drilldowns and filters. You can stay ahead of the curve by using forecasting. You can get email alerts when unexpected changes happen in your data, and you can share those insights with colleagues. For more information, see Amazon QuickSight Mobile.

November 5, 2019

Amazon QuickSight supports printing

Now you can print a dashboard or an analysis. For more information, see Printing.

October 17, 2019

Amazon QuickSight supports a new AWS Region

Amazon QuickSight is now available in Asia Pacific (Seoul) (ap-northeast-2). For more information, see AWS Regions, Websites, IP Address Ranges, and Endpoints.

October 17, 2019

Amazon QuickSight now supports visual-level formatting

Now, any formatting you apply from the field wells is applied only to the selected visual. For more information, see Formatting a Visual.

October 17, 2019

Transpose tables

In table visuals, you can now transpose columns and rows. For more information, see Tables.

October 10, 2019

Shared data sources

Share data sources with other users and groups. For more information, see Shared Data Sources.

October 10, 2019

SPICE enhancements

SPICE dashboards now support new wildcard filters on dimensions. You can now filter your data using any of the available wildcard filters: 'contains', 'starts with', 'end with', 'equals'. Additionally, SPICE dashboards now support new string functions (toString and parseDecimal) and two new date functions (parseDate and formatDate). For more information, see Calculated Fields.

October 10, 2019

New publishing options for dashboards

Control your user experience with more publishing options for your dashboards. These options include ability to toggle the filter pane, tooltips, drill up/down, and more. For more information, see Publish a Dashboard.

October 10, 2019

New median function

Amazon QuickSight supports median as a new aggregation. For more information, see median.

October 10, 2019

New filter functionality

Amazon QuickSight now supports additional relative date filter options. For more information, see Date Filters.

October 10, 2019

New aggregations for fields

You can now use Nth percentile, median, standard deviation, and variance in field wells, filters, and ML Insights. For more information, see Field Aggregations.

October 10, 2019

Filter for context

You can now filter text using the following wildcard comparison types: contains, does not contain, begins with, and ends with. For more information, see Text Filters.

October 10, 2019

Use the power operator (^) in SPICE

Amazon QuickSight now supports using the power operator (^) on SPICE datasets. You can use the power operator with any numeric field, with any valid exponent. For example, "revenue ^ 0.5" computes the square root of the revenue field. For more information, see Arithmetic and Comparison Operators.

September 11, 2019

Use string functions in SPICE

Now you can use string functions for calculated fields in your analyses based on SPICE datasets. For more information, see Functions by Category.

September 11, 2019

Use level-aware aggregations to control your calculations

Amazon QuickSight now supports level-aware aggregation calculations. Using this feature, you can perform aggregations at prefilter and preaggregation levels, before aggregations that happen in the display. This helps you explore more advanced query-building strategies than ever before. For more information, see Level-Aware Aggregations.

September 11, 2019

Sort your anomalies

Now you can choose how to sort anomalies on the insight widget and in the anomaly exploration page. Choosing how to prioritize anomalies can help you identify the anomalies that are the most important to you. For more information, see Using ML-Powered Anomaly Detection.

September 11, 2019

Put 100 million rows into a SPICE dataset

We changed the SPICE dataset limit from 25GB to 100 million rows for Enterprise edition (and 25 million rows for Standard edition). For more information, see SPICE Data Source Limits.

September 11, 2019

Rename your dashboard, keep your settings

Amazon QuickSight now supports renaming your published dashboards in place. You can change the name and still keep your settings and subscribers. For more information, see Publishing a Dashboards.

September 6, 2019

New visual type: Word clouds

Amazon QuickSight supports word cloud visuals that are based on different aggregations over any dimension in your dataset. You can drill down, focus on specific data points, and apply specific colors to data points on the word cloud. For more information, see Word Clouds.

September 5, 2019

Filter out the last N time periods

Amazon QuickSight lets you exclude a specific number and type of time periods from a time range (after) filter. For more information, see Adding a Date Filter.

September 5, 2019

Amazon QuickSight new feature to mark favorites

Mark your favorite dashboards and analyses so you can come back to them quickly. For more information, see Using the Amazon QuickSight Start Page.

September 5, 2019

Amazon QuickSight Enterprise edition adds anomaly alerts

Your readers can subscribe themselves to anomaly alerts on dashboards to get the latest ML-powered anomaly detection and contribution analysis by email. For more information, see Using Data Dashboards.

September 5, 2019

Detect anomalies with less data

In Amazon QuickSight Enterprise edition, we lowered the required minimum data points to 15 for training anomaly detection. For more information, see Data Set Requirements for Using ML Insights with Amazon QuickSight.

August 1, 2019

Amazon QuickSight supports new AWS Regions

Amazon QuickSight is available in Europe (London) and Europe (Frankfurt). Also, you can now connect to Active Directory in any AWS Region supported by Amazon QuickSight, except Asia Pacific (Singapore) and Asia Pacific (Sydney). For more information, see AWS Regions and IP Address Ranges.

August 1, 2019

Amazon QuickSight adds custom colors for charts.

With the Amazon QuickSight enhanced color picker, you can choose custom colors for charts where color customization is supported. The enhanced color picker also retains the eight most recently used custom colors for easy selection across multiple charts. For more information, see Changing Visual Colors.

August 1, 2019

Embedding for Active Directory

In Amazon QuickSight Enterprise edition, you can now embed dashboards for users authenticated through Active Directory. For more information, see Embedding Dashboards.

July 11, 2019

Granular access control for using AWS services from Amazon QuickSight

In Amazon QuickSight Enterprise edition, you can scope down your security policies to allow specific people access to specific AWS resources. You can attach and detach IAM policies in the Amazon QuickSight interface, simplifying finer control over who can access your AWS data sources. For more information, see Controlling Access to AWS Resources.

June 14, 2019

Tabs for dashboards and analyses

Amazon QuickSight now supports multiple sheets inside of analyses and dashboards. You can add multiple tabs to your dashboards, utilize URL actions and on-screen controls to simplify navigation, and filter across all of your sheets. For more information, see Multiple Sheets.

June 11, 2019

New functions

Amazon QuickSight now supports functions Variance and Standard Deviations as both aggregation and table calculation. You can create Sample and Population variants for both the functions. You can create these calculations through the calculations editor in analysis mode. Functions by Category

June 11, 2019

New Visual Types

You can now use Amazon QuickSight to chart your data on a customizable gauge and donut charts. For more information, see Visual Types.

June 11, 2019

Hide/Show columns in table visualizations

In Amazon QuickSight, you can hide or show columns in visualizations that use the table visual type. For more information, see Customizing a Visual.

June 11, 2019

Conditional String Functions on SPICE

We added support for ifelse in analyses that use SPICE. For more information, see ifelse

June 11, 2019

Choose period granularity for date differences

We added an optional parameter to dateDiff so you can show differences between dates in the period you choose (years, months, and so on). For more information, see dateDiff.

June 11, 2019

Duplicate visuals

In Amazon QuickSight, you can now duplicate visuals. For more information, see Duplicating a Visual.

May 21, 2019

Angled data labels

In Amazon QuickSight, data labels that are too long are now angled by default on vertical bar, combo, and line charts. For more information, see Customizing Data Labels.

May 21, 2019

New languages added

Amazon QuickSight is now available in 10 languages: English, German, Spanish, French, Portuguese, Italian, Japanese, Korean, Simplified Chinese, and Traditional Chinese. For more information, see Choosing a Language in Amazon QuickSight.

April 8, 2019

New aggregation function

Amazon QuickSight supports aggregating by percentile. This function helps you understand the distribution of your data. For more information, see percentile.

April 8, 2019

Customize how many data points to display

You can now format your visuals to display a custom number of data points or groups before showing the "other" category. This feature is available for bar charts, combo charts, line charts, pie charts, heat maps, and tree maps. For more information, see Customizing a Visual.

April 8, 2019

ML-powered forecasting

With forecasting powered by machine learning and what-if analyses in Amazon QuickSight, nontechnical users can now easily forecast their key business metrics. No ML expertise or Microsoft Excel data modeling is required. The built-in ML algorithm in Amazon QuickSight is designed to handle complex real-world scenarios. Amazon QuickSight uses ML to provide more reliable forecasts than traditional means. For more information, see Forecasts and What-Ifs.

March 14, 2019

ML-powered anomaly detection

Amazon QuickSight uses proven Amazon technology to continuously run ML-powered anomaly detection on millions of metrics and billions of data points. This anomaly detection enables you to get deep insights that are often buried in the aggregates, not visible in plain sight, and not scalable with manual analysis. With ML-powered anomaly detection, there's no need for manual analysis, custom development, or ML domain expertise. For more information, see Anomaly Detection.

March 14, 2019

Automatic narratives

Automatic narratives provide key insights in everyday language, embedded contextually in your dashboard, saving hours on manual analysis. With automatic narratives, Amazon QuickSight interprets the charts and tables in your dashboard and provides a number of suggested insights in natural language. Depending on the shape and form of your data, you might get different suggestions. For example, you might see what the day-over-day changes look like, what was the highest sales date, or what the growth rate is. Or you might see what the forecast looks like for the next seven days. As the author of the dashboard, you can customize the computations and business language for your needs. You can use automatic narratives to effectively tell the story of your data in plain language. For more information, see Narrative Insights.

March 14, 2019

Previous Updates

The following table describes the important changes in each release of the Amazon QuickSight User Guide before March 4, 2019.

Change Description Date Changed
New features

Using custom window functions, you can calculate any aggregation for a defined window at the point of selection. You can define the window interval before and after any point in time. You can also do calculations for that window using the sum, average, minimum, maximum, and count functions. Doing this enables a moving window aggregation as you progress through your data points. For more information, see Table Calculation Functions Index.

Send email reports with data tailored to each of your users and groups. You can now create email reports for datasets that use row-level security. Amazon QuickSight generates a custom email snapshot for each user or group based on their data permission that is defined in the dashboard. RLS for email reports works for both scheduled and ad hoc emails. For more information, see Sending Reports by Email.

Amazon QuickSight now supports unbounded cardinality. That means you can have more than 10,000 values in your control or filter. For more information, see Using a Control with a Parameter in Amazon QuickSight.

You can create a datetime parameter that has no static default value. Filters on these parameters become active after you choose a value. For more information, see Adding a Date Filter.

March 4, 2019
New features

There are new table calculations available:

February 7, 2019
New features

Amazon QuickSight supports emailing reports that use row-level security, using controls with unbounded cardinality, and creating datetime parameters with no default values. For more information, see the following:

January 22, 2019
New features

We added conditional aggregations, including sumIf, countIf, minIf, maxIf, avgIf, and distinct_countIf.

Pivot tables now support infinite scrolling through millions of rows. You can add up to 20 fields for columns, and 20 fields for rows. Plus, you can add subtotals and totals to rows and columns.

For more information, see the following:

January 10, 2019
New feature

We enhanced the join editor to increase usability and functionality. You can now add tables from one or more schemas on the same data source, or add the same table twice.

For more information, see Joining Data.

January 3, 2019
New SDK

You can embed dashboards and manage users or groups by using the Amazon QuickSight SDKs. For more information, see Developing with Amazon QuickSight.

November 27, 2018
New features

You can use groups with row-level security (RLS), and you can add cascading controls for parameters. For more information, see the following:

November 20, 2018
Function renamed

We renamed the percentile function to make it more intuitive. Its new name is percentileRank. For more information, see percentileRank.

November 12, 2018
New features

Use a top and bottom filter to show the top or bottom n for the field you choose, based on values in another field. For example, you could choose to show the top five sales people based on revenue. For more information, see Adding a Text Filter.

Use cascading controls to limit the values displayed in the controls, so they only show values that are relevant to what is selected in other controls. For more information, see Setting Up Parameters in Amazon QuickSight.

November 1, 2018
New feature

Use JSON native data types with parseJson. For more information see, parseJson.

October 30, 2018
New features

Use date functions to find out what quarter a date is in:

Add parameters to URLs. For more information see, Using Parameters in a URL.

September 10, 2018
New features

You can sort strings in SPICE datasets. For more information on these features, see Sorting Visual Data in Amazon QuickSight

August 20, 2018
New features

You can schedule emailed reports, and add data labels to your visuals.

For more information on these features, see the following sections:

August 15, 2018
New features

You can create table calculations, using aggregated measures to discover how dimensions influence measures or each other. Also, you can visualize time data at granularities as low as one minute.

For more information on these features, see the following sections:

August 8, 2018
New features

You can replace datasets, customize labels, and format dimensions that are aggregated with count and count distinct. Also, new visuals start out smaller in size.

For more information on these features, see the following sections:

June 21, 2018
New features and a new AWS Region

You can upgrade your Amazon QuickSight subscription from Standard edition to Enterprise edition. In Enterprise edition, Amazon QuickSight supports usage-based pricing for users in the reader role, sharing dashboards with all users in the reader role, and hourly refresh of datasets. Amazon QuickSight also supports private connections to data in a VPC with a private subnet in Enterprise edition.

In both editions, Amazon QuickSight supports parameters with on-sheet controls, dashboard co-ownership, custom URL actions, and 25-GB SPICE datasets.

Also, Amazon QuickSight is available in Asia Pacific (Tokyo).

For more information on these features, see the following sections:

May 30, 2018
New feature

Amazon QuickSight supports quick sorting from axis labels, duplicating datasets, and showing or hiding totals on tabular reports. Also, you can add custom SQL to a dataset earlier in the creation workflow. For more information on these features, see the following sections:

May 25, 2018
New features

You can use Amazon QuickSight to connect to Software as a Service (SaaS) providers. For more information, see Software as a Service (SaaS) Data.

You can import JSON files to Amazon QuickSight. For more information, see JSON Data. You can also parse JSON fields in a CSV file. For more information, see parseJson.

April 9, 2018
New feature

You can use Amazon QuickSight with Amazon S3 files that are in a different AWS account. For more information, see Datasets Using S3 Files in Another AWS Account.

November 20, 2017
New visual types

You can create visuals using maps. You can also view tabular data in a visual. For more information on preparing geospatial data for use in a visual, see Adding Geospatial Data. For more information on creating a geospatial visual, see Using Geospatial Charts (Maps). For more information on using tabular reports, see Using Tables as Visuals.

November 20, 2017
New features Amazon QuickSight can support 1000 columns in a dataset. For more information, see Data Source Quotas. Calculated fields are supported in SPICE datasets. For more information, see Adding a Calculated Field to an Analysis. Also, high cardinality values, which often display as a long tail on a visual, are placed into a category called other. For more information, see Working with Visual Types in Amazon QuickSight. November 20, 2017

New feature

In Enterprise edition, you can restrict access to a dataset by adding row-level security. To learn more, see Using Row-Level Security (RLS) to Restrict Access to a Dataset.

October 20, 2017

New visual type

You can create visuals using combo charts. To learn more about combo charts, see Using Combo Charts.

October 20, 2017
New features Amazon QuickSight supports creating custom aggregations for calculated fields in analyses, custom date formats, and copies of dashboards. For more information on aggregating calculated fields, see Using Aggregate Functions in Calculated Fields . For more information on using unsupported dates by creating a custom date format, see Using Unsupported or Custom Dates. For more information on duplicating dashboards, see Copying a Dashboard. September 25, 2017

New feature

You can combine multiple filters using the And/Or operators. To learn more about filter groups, see Adding a Compound Filter with And/Or Operators.

August 31, 2017

New data source

Amazon QuickSight supports Amazon S3 Analytics.

August 31, 2017
New Features Amazon QuickSight supports importing ZIP files from Amazon S3. There is also a new search feature, to simplify finding analyses, datasets, and dashboards. For more information on the search feature, see Using the Amazon QuickSight Console. August 31, 2017
New AWS Regions Amazon QuickSight is now available in Asia Pacific (Singapore) and Asia Pacific (Sydney). August 8, 2017

New feature

Amazon QuickSight supports Snowflake cloud data warehouse.

 July 31, 2017

New feature

Amazon QuickSight added a new aggregation: Count Distinct. To learn more, see Changing Field Aggregation.

July 19, 2017

New feature

Amazon QuickSight supports exploring Amazon S3 analytics data from an Amazon QuickSight dashboard that you reach from the AWS Management Console. To learn more, see Exploring Your AWS Data in Amazon QuickSight.

July 5, 2017

New feature

Amazon QuickSight supports Federated Single Sign-On (SSO) in Enterprise Edition. To learn more, see Using Identity Federation and Single Sign-on (SSO) with Amazon QuickSight.

May 25, 2017

New feature

Amazon QuickSight supports Amazon Redshift Spectrum. To learn more, see Enabling Access to Amazon Redshift Spectrum .

May 25, 2017

New feature

Amazon QuickSight supports Federated Single Sign-On (SSO) in Standard Edition. To learn more, see Using Identity Federation and Single Sign-on (SSO) with Amazon QuickSight.

May 25, 2017

New feature

Amazon QuickSight supports just-in-time (JIT) user provisioning through the following policy actions: quicksight:CreateUser and quicksight:CreateAdmin. To learn more, see IAM Policy Examples for Amazon QuickSight.

May 25, 2017

New feature

Amazon QuickSight supports direct connections to Teradata 14.0 and later.

May 25, 2017

New feature

Amazon QuickSight added relative date filters for datasets and visuals. To learn more, see Adding a Date Filter.

May 25, 2017

New feature

Amazon QuickSight supports connecting to Apache Spark and Presto. To learn more, see Creating a Data Source Using Apache Spark and Creating a Data Source Using Presto.

May 3, 2017

New feature

Amazon QuickSight supports operational logging with AWS CloudTrail. To learn more, see Logging Operations with AWS CloudTrail.

April 28, 2017

New feature

Amazon QuickSight is available in US East (Ohio). To learn more about AWS Regions, see AWS Regions, Websites, IP Address Ranges, and Endpoints.

April 11, 2017

New feature

  • You can use the AD Connector with Amazon QuickSight. To learn more about managing Enterprise users, see Managing User Access Inside Amazon QuickSight.

  • You can add key performance indicators (KPIs) to your visualizations. To learn more, see Using KPIs.

  • You can import .xlsx files with headers and footers, comments, formatting, filter header, sort, frozen panel/header, hidden columns, groups, and formulas / references. You can also limit your import to a specific range. To learn more about importing ranges, see Choosing File Upload Settings.

April 6, 2017

New feature

You can now export to a comma-separated value (CSV) format file using Amazon QuickSight. To learn more, see Exporting Data.

March 21, 2017

New feature

You can now schedule data refreshes for SPICE datasets. To learn more, see Refreshing Data.

February 14, 2017

New feature

You can now connect to Amazon Athena databases and use them as data sources in Amazon QuickSight. To learn more, see Creating a Dataset Using Amazon Athena Data.

December 22, 2016

New edition

Amazon QuickSight now offers an Enterprise edition as well as a Standard edition. Both editions offer a full set of features for creating and sharing data visualizations, and Enterprise edition additionally offers encryption at rest and Active Directory integration. When you choose to use Enterprise edition, you select a Microsoft Active Directory directory in AWS Directory Service and use that active directory to identify and manage your Amazon QuickSight users and administrators. To learn more, see Different Editions of Amazon QuickSight.

December 15, 2016

New guide

This is the first release of Amazon QuickSight User Guide.

November 15, 2016