Amazon QuickSight
User Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

What's New in Amazon QuickSight

Find out what's new in Amazon QuickSight.

  • Get our updates in a monthly email! Topics include all the new features and product enhancements, how-to videos, customer stories, tips, events, and more. Sign up for our newsletter.

  • Attend the Amazon QuickSight monthly customer webinar live with the Amazon QuickSight product team! Topics include demos and tutorials on all of the new features that we launch. Register for the webinar.

  • To learn how to use ML Insights in Amazon QuickSight, you can watch this video:

Use level-aware aggreations 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 2019

Put 100 million rows into a SPICE dataset

We changed the SPICE data set 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 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 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 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 2019

Amazon QuickSight Enterprise edition adds anomaly alerts

Now 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 2019

Amazon QuickSight's new favorite feature

We believe that not everything is the same! Amazon QuickSight added the ability to bookmark your favorite dashboards and analyses so you can come back to them quickly. For more information, see Using the Amazon QuickSight Start Page.

September 2019

Filter out the last N time periods

Amazon QuickSight adds the ability to exclude a specific number and type of time periods from a time range (after) filter. This is especially helpful for ML-powered anomaly detection. For more information, see Adding a Date Filter.

September 2019

New visual type: Word clouds

Amazon QuickSight now 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 2019

Amazon QuickSight supports new regions

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

August 2019

Amazon QuickSight adds custom colors for charts.

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

August 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 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 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 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. For more information, see Aggregations in Calculated Fields and Table Calculations.

June 2019

New visual types

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

June 2019

Create dashboards with multiple sheets

Amazon QuickSight now supports multiple sheets inside of analyses and dashboards. This allows you to build a comprehensive experience that is self-contained inside of a single dashboard. 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 2019

Conditional string functions on SPICE

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

June 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 2019

Hide 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 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 2019

Duplicate your visuals

In Amazon QuickSight, you can now duplicate visuals in the same sheet, or onto a different sheet. For more information, see Duplicating a Visual.

May 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 2019

Percentile aggregation

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

April 2019

Custom number of data points

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 the Number of Data Points to Display.

April 2019

ML-powered Anomaly Detection

Amazon QuickSight uses proven Amazon technology to continuously run anomaly detection powered by machine learning 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 anomaly detection powered by machine learning (ML), there's no need for manual analysis, custom development, or ML domain expertise. For more information, see ML-Powered Anomaly Detection.

March 2019

ML-powered Forecasting

With forecasting and what-if scenarios powered by machine learning, 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 ML-powered Forecasts and What-Ifs.

March 2019


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 suggestions such as what the day-over-day changes look like, what was the highest sales date, what the growth rate is at, and 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 Auto-narrative Insights.

March 2019

Custom window functions

Using custom window functions, you can calculate any aggregation for a defined window at the point your choose. You can define the window offsets you need. For more information, see Table Calculations.

March 2019

RLS support for email reports

You can now create email reports with data tailored to each of your users and groups, for data sets that use row-level security. Amazon QuickSight generates a custom email snapshot for each user or group based on the data permissions that are defined in the dashboard. Row-level security (RLS) for email reports works for both scheduled and ad hoc (one-time) emails. For more information, see Sending Reports.

March 2019

High cardinality filters

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 Parameter Controls.

March 2019

New table calculations

You can now create calculated fields with percentileOver, runningAvg, runningCount, runningMax, and runningMin. For more information, see Calculated Field Function and Operator Reference.

February 2019

Conditional aggregations

You can now create calculated fields to perform sumIf, countIf, minIf, maxIf, avgIf, and distinct_countIf. For more information, see Calculated Fields.

January 2019

Join editor enhancements

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 Tables.

January 2019

Pivot table enhancements

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 Pivot Tables.

January 2019

Join editor enhancements, cross schema data sources, and self joins

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 Tables.

January 2019

New API for embedding Amazon QuickSight dashboards

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

November 2018

New API operations for user and group management

Manage users or groups by using the Amazon QuickSight SDKs or by using the AWS CLI. For more information, see List of Actions by Function.

November 2018

RLS group support and cascading controls

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

November 2018

Top and bottom filters

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.

November 2018

Support for parseJSON data type in source tables

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

October 2018

Date functions and URL parameters

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

You can also add parameters to URLs. For more information, see Using Parameters in a URL.

September 2018

SPICE sorting

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

August 2018

Scheduled email reports

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

For more information on these features, see the following:

August 2018

Table calculations and time data granularity

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:

August 2018

Customize labels, format counts, replace data sets, and new smaller visuals

You can replace data sets, 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:

June 2018

New reader role and usage-based pricing, plus ability to upgrade subscriptions, and a new 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 data sets. Also, Amazon QuickSight is available in Asia Pacific (Tokyo).

For more information on these features, see the following:

May 2018

New reader role and usage-based pricing, upgrade subscriptions, private connections with VPC, and more

Amazon QuickSight 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 data sets.

For more information on these features, see the following:

May 2018