Amazon QuickSight
User Guide

What's New in Amazon QuickSight

Find out what's new in Amazon QuickSight.

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

  • To learn more about ML Insights in Amazon QuickSight, you can watch this video.

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

Auto-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 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