Amazon QuickSight
User Guide

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.

November 2019

View history for SPICE ingestion on your Amazon QuickSight data sets – You can now view the ingestion history for SPICE data sets 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.

Enhance interactivity on your dashboards using Amazon QuickSight Actions – You can use Amazon QuickSight actions to build simple point-and-click filtering between visuals and across data sets. Use the one-click setup to create a filter action across your dashboard. Aslo, setup for custom URLs now appears in the Action menu at left, rather than in the on-visual menu. For more information, see Custom Actions in Amazon QuickSight. For the feature video see QuickSight Actions.

Amazon QuickSight supports dynamic sheet titles – You can now use parameters in sheet titles to make the context of the dashboard more clear to the reader. For more information, see Formatting a Visual.

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; explore your data with drilldowns and filters; stay ahead of the curve via forecasting; get email alerts when unexpected changes happen in your data; and share those insights with colleagues. For more information, see Amazon QuickSight Mobile. For the feature video, see QuickSight Mobile App.

Use Amazon QuickSight to join data from multiple data sources

Now you can use Amazon QuickSight to create data sets that join multiple data sources using a drag-and-drop UI. You can directly join tables from multiple database types and multiple file types in any combination. Joining in Amazon QuickSight can help you avoid the need to duplicate you data to a central data store before reporting on it. For more information, see Joining Tables. For the feature video, see Cross-source data joins.

October 2019

Relative filtering on anchor and future dates

Amazon QuickSight now supports additional relative date filter options. You can filter for periods ahead of the current date period. You can set a constant period or dynamically change it using controls. And, you can filter relative to a custom "anchor" date. For more information, see Date Filters.

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

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.

Amazon QuickSight supports printing

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

New publishing options for dashboards

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

Shared data sources

Amazon QuickSight now supports sharing data sources with users and groups. You can create data sources from any supported data source and share with users and groups, like you can do with data sets, analyses, and dashboards. Data source co-owners can now edit the underlying SQL for custom SQL data sets. Data source sharing is supported on all types of data sources except for S3 analytics and file-based data sets. For more information, see Shared Data Sources.

New aggregations for fields

You can now aggregate your visuals by statistical calculations such as Nth percentile, median, variance, and standard deviation. For more information, see Field Aggregations.

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.

Transpose table columns and rows

You can now transpose rows and columns on table charts. Transposing rows and columns on table visuals allows you to swap orientation of rows and columns to represent data in different views. For more information, see Tables.

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

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.

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.

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.

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.

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.

Amazon QuickSight new feature to mark favorites

Amazon QuickSight has 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.

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.

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.

August 2019

Amazon QuickSight supports new AWS Regions

Amazon QuickSight is available in EU (London) and EU (Frankfurt). Also, you can now connect to Microsoft 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.

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 8 most recently used custom colors for easy selection across multiple charts. For more information, see Changing Visual Colors.

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.

July 2019

Embedding for Microsoft Active Directory

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

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

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.

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.

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.

Conditional string functions on SPICE

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

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

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.

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

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.

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

Percentile aggregation

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

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.

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

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.

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.

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.

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.

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.

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

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

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.

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.

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.

2018

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