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, customer stories, tips, events, and more. Sign up for our newsletter.

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

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

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.

Amazon QuickSight Adds Min/Max Dates – You can now use minimum and maximum date aggregations in tables and pivot tables. For more information, see max and min.

February 2020

Improvements to 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.

New customizable minimum delta values 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.

January 2020

Amazon SageMaker integration now available in more AWS Regions – The public preview for integrating Amazon 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.

December 2019

New functions for level-aware aggregations in Amazon QuickSight – Now you can use rank, denseRank, and percentileRank for level-aware aggregations. For more information, see Using Level-Aware Aggregations.

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.

Private VPC support for Presto in Amazon QuickSight – Now Presto can use a VPC connection. For more information, see Supported Data Sources for VPCs.

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.

November 2019

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

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.

New Amazon QuickSight API operations – Amazon QuickSight launches new API operations to programmatically manage your data, dashboards, and IAM-linked fine-grained access control capabilities. 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 schema 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. For the feature video, see the QuickSight API Overview.

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.

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.

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.

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.

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 datasets. Use the one-click setup to create a filter action across your dashboard. Also, the 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 clearer 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 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. 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 datasets 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 datasets, analyses, and dashboards. Data source co-owners can now edit the underlying SQL for custom SQL datasets. Data source sharing is supported on all types of data sources except for S3 analytics and file-based datasets. 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 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.

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 Europe (London) and Europe (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 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 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 datasets 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 datasets. 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.