Document history for the Amazon QuickSight User Guide - Amazon QuickSight

Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.

To find a feature or item, use the Quick search bar.

For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight.

Document history for the Amazon QuickSight User Guide

This page describes changes to the Amazon QuickSight User Guide. For notifications about these documentation changes, subscribe to the RSS feed using the link near the top of this page.

To find out what's new in Amazon QuickSight, see What's New with Analytics. To find out about changes to the Amazon QuickSight service, sign up for the Amazon QuickSight newsletter.

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.

Note

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

ChangeDescriptionDate

New Q pane

Amazon QuickSight users that are opted in to the Generative BI perview can now use the Q pane to access all relevant Generative BI features. For more information, see Using Generative BI with Amazon Q in QuickSight.

March 25, 2024

New region: China (north)

Amazon QuickSight is now available in China (Beijing) (cn-north-1). For more information, see AWS Regions, websites, IP address ranges, and endpoints.

January 25, 2024

Amazon Q in QuickSight

Amazon Q integrates with Amazon QuickSight to give QuickSight users access to a suite of new generative BI capabilities. With Amazon Q in QuickSight, you can utilize the generative BI authoring experience, create executive summaries of your data, ask and answer questions of data, and generate data stories. For more information, see Using generative BI with Amazon Q in QuickSight.

November 28, 2023

Trusted identity propagation in Amazon QuickSight

QuickSight authors can now create data sources with trusted identity propagation, which allows database administrators to centrally manage data security in Amazon Redshift and automatically apply all data security rules to data consumers in QuickSight. For more information, see Enabling trusted identity propagation with Amazon Redshift.

November 26, 2023

Runtime filtering and theming for embedded dashboards and visuals

QuickSight authors can now customize filters and themes for embedded dashboards and visuals. For more information, see Customizing embedded assets.

November 17, 2023

Custom time zones and week start days in Amazon QuickSight

QuickSight authors can now restrict the functionality that people can access in Amazon QuickSight. For more information, see Customizing access to the Amazon QuickSight console.

November 17, 2023

Custom time zones and week start days in Amazon QuickSight

QuickSight authors can now turn on SPICE auto capacity purchasing to allow Amazon QuickSight to automatically manage your QuickSight account's SPICE capacity. For more information, see Turning SPICE auto capacity purchasing on.

November 17, 2023

Amazon EventBridge integration

You can now integrate your Amazon QuickSight account with Amazon EventBridge. For more information, see Amazon QuickSight EventBridge integration.

November 17, 2023

New look for the QuickSight analysis workspace

We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text. For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight.

November 16, 2023

Custom time zones and week start days in Amazon QuickSight

QuickSight authors can now set custom time zones and week start days for their analyses. For more information, see Customize date and time values of an analysis.

November 14, 2023

Float decimal type

Decimal values in calculated fields of datasets that are stored in SPICE can now be assigned the Fixed or Float decimal data type. For more information, see Supported data types and values.

November 8, 2023

Custom total values in Amazon QuickSight

QuickSight authors can now define the total and subtotal aggregations for their table or pivot table visuals from the field wells. For more information, see Custom total values.

October 25, 2023

Restricted and unrestricted shared folders in Amazon QuickSight

QuickSight authors can now create restricted and unrestricted shared folders with the QuickSight CLI to help organize and manage the permissions of important QuickSight assets. For more information, see Organizing assets into folders for Amazon QuickSight.

October 24, 2023

New data source

QuickSight now supports connecting to a Trino data source. For more information, see Using Trino with Amazon QuickSight.

October 20, 2023

New data source

QuickSight now supports connecting to a Starburst data source. For more information, see Using Starburst with Amazon QuickSight.

October 20, 2023

SageMaker Canvas integration

QuickSight authors can now export data into SageMaker Canvas to build ML models that can be sent back to QuickSight and applied to analyses and dashboards. For more information, see Build predictive models with SageMaker Canvas.

October 6, 2023

Managed policy update

The AWSQuickSightSageMakerPolicy is updated to reflect the Amazon QuickSight–SageMaker integration. For more information, see AWS managed policy: AWSQuickSightSageMakerPolicy.

October 6, 2023

Amazon Redshift run-as role

QuickSight authors can now connect Amazon Redshift data with run as role to enhance data security with fine grained access policies. For more information, see Run queries as an IAM role in Amazon QuickSight.

October 6, 2023

Generative BI public preview

The public preview for Generative BI is now available to users who have a QuickSight Q add-on subscription. For more information, see Working with Generative BI in QuickSight Q.

September 28, 2023

Freeze table columns in Amazon QuickSight

You can now freeze single or groups of table columns in Amazon QuickSight. For more information, see Freeze columns to table visuals.

September 26, 2023

Enhanced KPI options in Amazon QuickSight

New layouts and formatting options for KPIs are now available in Amazon QuickSight. For more information, see Using KPIs.

September 15, 2023

Scaled folders in Amazon QuickSight

You can create scaled folders that can be shared with thousands of namespaces at once with the Amazon QuickSight APIs. For more information, see Creating scaled folders with the AWS CLI.

August 30, 2023

Excel format reports in Amazon QuickSight

You can now create and schedule Excel snapshot reports of a dashbaord in Amazon QuickSight. For more information, see Scheduling and sending reports by email.

August 24, 2023

Add contextual row subtitles to pivot tables in Amazon QuickSight

You can now add contextual row subtitles to pivot tables in Amazon QuickSight. For more information, see Totals and subtotals.

August 16, 2023

New layouts for pivot tables in Amazon QuickSight

Amazon QuickSight now supports two types of layout for pivot tables: tabular and hierarchy. For more information, see Choosing a layout.

August 11, 2023

Default column width Amazon QuickSight

You can now set the default column width of your pivot table visuals in Amazon QuickSight. For more information, see Row and column size in tables and pivot tables in Amazon QuickSight.

August 11, 2023

Amazon QuickSight integration with IAM Identity Center

You can now integrate your Amazon QuickSight Enterprise edition account with IAM Identity Center. For more information, see Configure your Amazon QuickSight account with IAM Identity Center.

August 11, 2023

Embedded callback actions at runtime

You can now use embedded datapoint callback actions to build tighter integrations between your SaaS application and your Amazon QuickSight embedded dashboards and visuals. For more information, see Add embedded callback actions to at runtime in Amazon QuickSight.

August 9, 2023

Working with field level coloring in Amazon QuickSight

You can now assign specific colors to specific field values across all visuals in a QuickSight analysis or dashboard. For more information, see Working with field level coloring in Amazon QuickSight.

July 13, 2023

Small multiples axis options in Amazon QuickSight

You can now configure the x and y axes for each individual panel of a small multiples visual in Amazon QuickSight. For more information, see Small multiples axis options.

July 13, 2023

Use the analysis menu in Amazon QuickSight

You can now use menu options to efficiently perform tasks without needing to manually navigate through your analysis in Amazon QuickSight. For more information, see The analysis menu.

July 7, 2023

Advanced report scheduling options in Amazon QuickSight

You can now access more advanced PDF report scheduling options in Amazon QuickSight. For more information, see Configuring email report settings for a dashboard in QuickSight Enterprise edition.

June 30, 2023

Format visual language data based on language settings in Amazon QuickSight

You can now choose how your numeric data values appear in visuals so that they align with the regional language that you have chosen in Amazon QuickSight. For more information, see Formatting visual numeric data based on language settings in Amazon QuickSight.

May 26, 2023

Create geospatial heatmaps in Amazon QuickSight

You can now create geospatial heatmaps in Amazon QuickSight. For more information, see Geospatial heatmaps in Amazon QuickSight.

May 26, 2023

Work with Q topics using the QuickSight CLI in Amazon QuickSight

You can now work with QuickSight Q topics using the Amazon QuickSight command line interface (CLI). For more information, see Work with QuickSight Q topics using the Amazon QuickSight CLI.

May 4, 2023

Use dataset parameters in Amazon QuickSight

You can now use dataset parameters in direct query to dynamicaly customize their datasets and apply reusable logic to your datasets. For more information, see Using dataset parameters in Amazon QuickSight.

May 4, 2023

Enhanced options for scatter plots in Amazon QuickSight

You can now plot unaggregated values on scatter plots in Amazon QuickSight. For more information, see Using scatter plots.

May 4, 2023

Create and update VPC connections Amazon QuickSight

You can now create and update VPC connections in Amazon QuickSight. For more information, see Using dataset parameters in Amazon QuickSight.

May 4, 2023

Create tag-based RLS rules using the OR condition in Amazon QuickSight

You can now add the OR condition to your tag-based rules to further customize the way data is presented to your QuickSight account users. For more information, see Using row-level security (RLS) with tag-based rules to restrict access to a dataset when embedding dashboards for anonymous users.

April 7, 2023

Threshold alerts on Table and Pivot table visuals in Amazon QuickSight

You can now create threshold alerts for Table and Pivot table visuals in Amazon QuickSight. For more information, see Working with threshold alerts in Amazon QuickSight.

March 17, 2023

Hide collapsed columns in Amazon QuickSight table visuals

You can now customize the way Amazon QuickSight readers view pivot tables to make them easier to read and understand at a glance. For more information, see Pivot table layout options.

March 9, 2023

Enhanced embedding capabilities in Amazon QuickSight

You can now use QuickSight's Embedding SDK (v2.0) to improve developer experience when embedding QuickSight in your application or website. For more information, see Embedding with the QuickSight APIs.

March 9, 2023

Run queries with Amazon S3 datasources in Amazon QuickSight

You can now enhance data security by using fine-grained access policies rather than broader permissions for data sources connected to Amazon S3 in Amazon QuickSight. For more information, see Run queries with Amazon S3 data sources.

February 21, 2023

Radar charts in Amazon QuickSight

You can now create radar charts in Amazon QuickSight. For more information, see Using radar charts in Amazon QuickSight.

January 30, 2023

Data bars for tables and pivot tables in Amazon QuickSight

You can now use data bars to add visual context to your table visuals in Amazon QuickSight. For more information, see Adding data bars to tables in Amazon QuickSight.

January 24, 2023

New question types: Boolean, Forecast, and Why

You can now enter boolean, forecast, and why questions into the QuickSight Q search bar. For more information, see Asking questions with Amazon QuickSight Q.

November 29, 2022

Automated data prep for QuickSight Q

Amazon QuickSight Q now uses AI-enhanced data preparation to automatically create topics that are relevant to your end users. For more information, see Working with Amazon QuickSight Q topics.

November 29, 2022

Paginated reporting

You can now create, schedule, and share highly formatted multi-page reports in Amazon QuickSight. For more information, see Working with paginated reports in Amazon QuickSight.

November 28, 2022

Embedding the Q search bar for anonymous (unregistered) users

You can now embed the QuickSight Q search bar for anonymous (unregistered) users. For more information, see Embedding the Amazon QuickSight Q search bar for anonymous (unregistered) users.

November 19, 2022

Asset management

You can now manage all of the assets un your Amazon QuickSight account in one unified view. For more information, see Amazon QuickSight asset management.

November 19, 2022

Text boxes

You can now add static and dynamic textual content using text boxes in Amazon QuickSight. For more information, see Using text boxes.

November 18, 2022

Small multiples

You can now create small multiples in line, bar, and pie chart visuals. For more information, see Using small multiples.

November 18, 2022

Set a reserved value in QuickSight datasets

You can now set a reserved value to determine the value of the Select all value of a dataset in Amazon QuickSight. For more information, see Setting up parameters in Amazon QuickSight.

November 18, 2022

Run queries as an IAM role in Amazon QuickSight

You can now enhance data security by using fine-grained access policies rather than broader permissions for data sources connected to Athena. For more information, see Run queries as an IAM role in Amazon QuickSight.

November 18, 2022

Pin Amazon QuickSight Q answers to your pinboard

You can now pin visuals from Q for easy access to frequently asked questions. For more information, see Pinning visuals in Amazon QuickSight Q.

November 18, 2022

Marker clustering on geospatial map visuals

You can now use marker clustering to improve readability of colocated points on a map. For more information, see Marker clustering on geospatial point maps in QuickSight.

November 18, 2022

Line chart customization

You can now add customizations to line chart visuals to emphasize what you want readers to focus on: color, line style, and markers. For more information, see Line and marker styling on line charts in QuickSight.

November 18, 2022

Connecting Amazon QuickSight accounts to Databricks

You can now use Amazon QuickSight to connect to Databricks on AWS. For more information, see Using Databricks in QuickSight.

November 18, 2022

Account termination protection

You can now use account termination protection to prevent someone from deleting a QuickSight user account accidentally or maliciously. For more information, see Deleting your Amazon QuickSight subscription and closing your account.

November 18, 2022

1 billion row SPICE datasets

Amazon QuickSight now supports SPICE datasets that contain up to 1 billion (1,000,000,000) rows or 1 terabyte (TB) of data. For more information, see SPICE quotas for imported data.

November 18, 2022

Monitor SPICE consumption metrics in Amazon CloudWatch

You can now monitor your QuickSight account's SPICE consumption metrics in Amazon CloudWatch. For more information, see Aggregate SPICE metrics.

November 8, 2022

Use AWS KMS to encrypt your SPICE datasets in Amazon QuickSight

You can now encrypt your SPICE datasets using the keys that you have stored in AWS KMS. This provides you with the tools to audit access to data and satisfy regulatory security requirements. For more information, see Key management.

October 27, 2022

Add datasets that contain row-level security (RLS) to Q topics

QuickSight Q now supports questions for access restricted datasets that use Row level Security (RLS) with user based rules. Readers can now ask questions about Topics that contain restricted access datasets and instantly receive accurate and pertinent answers based on access control rules defined by authors in RLS settings. For more information, see Adding datasets with row-level security (RLS) to a topic.

October 10, 2022

Use AWS Secrets Manager secrets instead of database credentials in Amazon QuickSight

Amazon QuickSight administrators can grant QuickSight read-only access to secrets they create in AWS Secrets Manager. These secrets can be used in place of database credentials when creating and editing data sources using the QuickSight API. For more information, see Using AWS Secrets Manager secrets instead of database credentials in Amazon QuickSight.

October 6, 2022

Visual Embedding

You can now embed visuals using a 1-click embed code or with the Amazon QuickSight API. For more information, see Embedding visuals with the Amazon QuickSight API.

August 25, 2022

Undo and redo changes in Q answers

You can now undo or redo any changes you make to a Q answer by choosing the undo or redo arrows in the Q search bar. For more information, see step six in Asking questions with Q.

August 22, 2022

Updates to the sign in experience

The sign in experience in QuickSight has been updated. For more information about how to sign in, see Signing in to Amazon QuickSight.

July 21, 2022

Bookmarks

You can now bookmark views of a dashboard. For more information, see Bookmarking views of a dashboard.

July 21, 2022

Base Maps

When creating map visuals in QuickSight, you can now change map base. For more information, see Changing base maps.

July 21, 2022

Q updates

You can now try QuickSight Q out for free before getting the Q add-on. For more information, see Trying Amazon QuickSight Q.

July 7, 2022

Rolling dates in filters and parameters

You can now set a rolling date on date range fiters and relative date parameters in analyses. For more information, see Creating range date filters in analyses and Setting up parameters.

July 5, 2022

Calculations update

You can now create level-aware calculations in QuickSight. You can specify at what level to group computations using level-aware calculation - aggregation (LAC-A) functions. You can also specify the window or partition to compute a calculation using level-aware calculation - window (LAC-W) functions (previously known as level-aware aggregations). For more information, see Using level-aware calculations.

July 5, 2022

Allowed domains

Developers can now add a domain at run-time to an allow list with the AllowedDomains parameter of a GenerateEmbedUrlForAnonymousUser or a GenerateEmbedUrlForRegisteredUser API call. For more information, see Allow listing domains at run-time with the QuickSight API.

July 5, 2022

Account provisioning

You can now sign up for an Amazon QuickSight account with the Amazon QuickSight API. For more information, see CreateAccountSubscription.

July 5, 2022

Monitoring data with Amazon CloudWatch

You can now monitor metrics for Amazon QuickSight dashboards, visuals, and dataset ingestions on Amazon CloudWatch to provide your readers with a consistent, high-performing, and uninterrupted experience on Amazon QuickSight. For more information, see Monitoring data in Amazon QuickSight.

June 22, 2022

Forecast boundaries

Authors can now set a minimum and maximum for forecasted values. For more information, see Forecasting and creating what-if scenarios .

June 16, 2022

Table and pivot table enhancements

Authors and Readers can now resize rows and columns in a table or pivot table visual. For more information, see Resizing rows and columns in tables and pivot tables.

June 14, 2022

Hiding fields in pivot tables

You can now hide fields in pivot table visuals. For more information, see Showing and hiding pivot table columns.

June 14, 2022

ML insights and forecasting for Q

Readers can now see key data insights and add forecasts to Q answers. For more information, see Asking questions with Amazon QuickSight Q.

June 2, 2022

What's New in Amazon QuickSight

To find out what's new in Amazon QuickSight, see the What's New page. What's New posts provide a brief overview of all QuickSight feature announcements as they are released.

June 1, 2022

Line chart updates

QuickSight now supports 10,000 data points for line charts. For more information, see Using line charts.

May 22, 2022

1-click public embedding

You can now embed dashboards for anyone on the internet in your public applications with a 1-click static embed code. For more information, see Enabling public access to dashboards with a 1-click embed code.

May 18, 2022

Creating and managing groups

You can now create and manage groups in the QuickSight console. For more information, see Creating and managing groups in Amazon QuickSight.

March 21, 2022

Automatic refresh controls for direct query

In QuickSight, filter controls are now refreshed every 24 hours for direct query. For more information, see Refreshing data.

March 8, 2022

Updating files in a dataset

You can now update files in a dataset to get the latest version of those files. For more information, see Updating files in a dataset.

January 27, 2022

Rich text formatting for titles and subtitles

QuickSight now offers rich text formatting for titles and subtitles, and the ability to add hyperlinks and parameters in titles. For more information, see Formatting a visual title and subtitle.

January 27, 2022

Comparative and cumulative date/time calculations

Comparative and cumulative period functions, such as year-over-year and year-to-date, are now supported in QuickSight. For more information, see Add comparative and cumulative date/time calculations in Amazon QuickSight.

January 27, 2022

Sharing dashboards

You now have the option to grant everyone in your Amazon QuickSight account access to a dashboard. You can also share a link to the dashboard with anyone who has access to it. For more information, see Sharing dashboards.

November 23, 2021

Customizing email report templates

You can now customize how dashboard email reports appear and behave for QuickSight account users. For more information, see Customizing email report templates.

November 23, 2021

1-click enterprise embedding

You can now embed dashboards for registered users in your internal applications with a 1-click static embed code. For more information, see Embedding dashboards for registered users with a 1-Click embed code.

November 23, 2021

New data source

QuickSight now supports connecting to an Exasol data source. For more information, see Supported data sources.

November 22, 2021

Dataset versioning

QuickSight now supports dataset versioning. For more information, see Reverting datasets back to previous published versions.

November 22, 2021

Adding datasets with RLS to Q topics

QuickSight Q topics now support datasets with row-level security (RLS). For more information, see Adding datasets with RLS to a Q topic.

November 19, 2021

Sheet change performance operations

QuickSight now only refreshes visuals when switching sheets if required. For more information, see Refreshing visuals.

November 12, 2021

Incrementally refresh a SQL-based dataset

In QuickSight Enterprise Edition, you can now refresh your SQL-based SPICE datasets incrementally within a look-back window of time. For more information, see Refreshing data.

October 25, 2021

Embedding the Q search bar

You can now embed the Q search bar in your application for registered users of QuickSight. For more information, see Embedding the QuickSight Q search bar for registered users.

October 22, 2021

Email syncing for federated users

In Enterprise Edition, QuickSight administrators can now restrict new users from using personal email addresses when provisioning through their identity provider (IdP) to QuickSight. For more information, see Configuring email syncing for federated users.

October 22, 2021

Adding RLS tags to a dataset

You can now add tag-based rules to a dataset in QuickSight when applying row-level security (RLS). For more information, see Using row-level security (RLS) with tag-based rules to restrict access to a dataset when embedding dashboards for anonymous users.

October 19, 2021

IP restrictions

You can now limit access to your organization's QuickSight account to a predefined list of Internet Protocol (IP) ranges. For more information, see Turning on Internet Protocol (IP) restrictions in Amazon QuickSight.

October 18, 2021

New table and pivot table styling options

You can now customize the look of tables and pivots tables. For more information, see Formatting tables and pivot tables.

October 12, 2021

New SPICE quota for imported data

In QuickSight Enterprise edition, you can now import up to 500 million rows into a SPICE dataset. For more information, see Data source quotas.

October 12, 2021

Links and images in tables

You can now add links to tables. You can also render links as images in tables. For more information, see Field styling.

October 12, 2021

Custom date formats

You can now customize how dates are formatted in your filter and parameter controls. For more information, see Customizing date formats.

October 8, 2021

QuickSight q

You can now ask questions about your data in the Q bar and get answers in the form of visuals. For more information, see Working with QuickSight q.

September 24, 2021

New geospatial region

QuickSight now supports creating geospatial charts for India. For more information about creating geospatial charts, see Using geospatial charts (maps).

September 22, 2021

Free-form layouts

You can now place visuals anywhere in your dashboard using precise coordinates. For more information, see Customizing dashboards and visuals.

September 22, 2021

Passing IAM roles to QuickSight

You can now pass IAM roles to QuickSight. For more information, see Using Amazon QuickSight with IAM.

September 15, 2021

Create datasets from existing datasets

You can now create datasets from existing datasets. For more information, see Creating a dataset using an existing dataset.

September 15, 2021

Updated AWS managed policy

Amazon QuickSight updated an existing AWS managed policy. For more information, see Amazon QuickSight updates to AWS managed policies.

September 8, 2021

New AWS managed policy

Amazon QuickSight added a new AWS managed policy. For more information, see Amazon QuickSight updates to AWS managed policies.

September 8, 2021

Forecast multiple measures

You can now forecast up to three measures in the same chart. For more information, see Forecasting and creating what-if scenarios.

August 30, 2021

Share your view of a dashboard

You can now share your view of a dashboard. For more information, see Sharing dashboards.

August 20, 2021

Hide the data zoom on a chart

You can now choose to show or hide the data zoom for your charts in Amazon QuickSight. For more information, see Formatting axes and Grid lines.

August 16, 2021

Row-level security with tags

You can now use row-level security (RLS) with tags to specify which data your (unauthenticated) users can see in an embedded Amazon QuickSight dashboard depending on who they are. For more information, see Using RLS with tags to restrict access to a dataset when embedding dashboards for anonymous users.

July 29, 2021

New embedding API operations

Amazon QuickSight has the following new API operations for embedding analytics: GenerateEmbedUrlForAnonymousUser and GenerateEmbedUrlForRegisteredUser. You can still use the GetDashboardEmbedUrl and GetSessionEmbedUrl API operations to embed dashboards and the QuickSight console, but they don't contain the latest embedding capabilities. For more information about using the new API operations, see Embedding overview. For more information on using the old API operations, see Embedding analytics using the old API operations.

July 29, 2021

Customizing charts

You can now hide the sort icon and the axis or field title in charts in Amazon QuickSight. For more information, see Formatting axes and Grid lines.

July 16, 2021

Threshold alert updates

You can now choose to be notified when there is no data to check your alert rule against in Amazon QuickSight. For more information, see Working with threshold alerts.

July 9, 2021

New chart type: Custom visual content

You can now embed webpages and online videos, forms, and images in your QuickSight dashboards using the custom visual content chart type. For more information, see Using custom visual content in Amazon QuickSight.

June 29, 2021

Feature improvements

You can now show totals for stacked bar charts. For more information, see Using bar charts.

June 29, 2021

Threshold alert updates

Dataset owners can now set a threshold alert evaluation schedule for a dataset in Amazon QuickSight. For more information, see Working with threshold alerts.

June 17, 2021

Duplicating analyses

You can now duplicate an analysis in Amazon QuickSight. For more information, see Duplicating an analysis.

June 17, 2021

Threshold alert updates

You can now choose how often you want to receive threshold alerts in Amazon QuickSight. For more information, see Working with threshold alerts.

May 25, 2021

Wildcard search

Amazon QuickSight now supports wildcard search. For more information, see Using wildcard search.

May 1, 2021

Threshold alerts

Amazon QuickSight now supports creating threshold alerts using KPI and Gauge visuals in dashboards. For more information, see Working with threshold alerts.

May 1, 2021

Service control policies

Amazon QuickSight now supports using service control policies (SCPs) to restrict how individuals in your organization can sign up for Amazon QuickSight. For more information, see Using service control policies to restrict Amazon QuickSight signup options.

April 26, 2021

Parameter improvements

Amazon QuickSight now supports dynamically displaying parameter values in titles and descriptions throughout charts and analyses. For more information, see Using parameters in titles and descriptions.

April 12, 2021

Feature improvements

Amazon QuickSight now supports selecting a time granularity for date and time range filters and datetime parameters. For more information, see Adding a date filter and Setting up parameters.

April 1, 2021

Export to PDF

Amazon QuickSight now supports PDF exports of the current sheet in dashboards and analyses. In Enterprise edition, you can now attach a PDF to email reports. For more information, see Exporting an analysis or dashboard as a PDF.

April 1, 2021

Seconds support for date fields

Amazon QuickSight now supports aggregating date fields at the second level. For more information, see Changing date field granularity.

March 30, 2021

Pivot table sorting improvements

Amazon QuickSight now supports sorting values in pivots tables by fields in the Rows and Columns field wells or by column headers. For more information, see Sorting pivot tables.

March 30, 2021

New feature

Amazon QuickSight now supports customizing tooltips in visuals. For more information, see Customizing tooltips in a visual.

March 16, 2021

Feature improvements

In Enterprise edition, Amazon QuickSight now supports computing anomalies for a time and measure field only, and computing the exact combination of fields in the Category field well. For more information, see Adding an ML insight to detect outliers and key drivers.

March 16, 2021

Line chart improvements

Amazon QuickSight now supports creating line charts with dual axes. For more information, see Creating a dual-axis line chart.

March 1, 2021

New formatting options for charts

Amazon QuickSight now supports hiding axis lines, axis labels, and grid lines, and also customizing the how axis labels appear in a chart. For more information, see Formatting axis lines, axis labels, and Grid lines.

February 5, 2021

New chart type: Sankey diagrams

Amazon QuickSight now supports creating Sankey diagrams. For more information, see Using sankey diagrams.

February 5, 2021

Field mapping improvements

Amazon QuickSight now supports updating field mapping between mismatched and missing fields when replacing a dataset in an analysis. For more information, see Replacing datasets.

February 5, 2021

Data prep enhancements

Amazon QuickSight now supports organizing fields into folders and subfolders when preparing or editing datasets. For more information see, Organizing fields into folders.

February 5, 2021

New features

In Enterprise edition, Amazon QuickSight now supports displaying anomaly ranges and multiple anomalies when exploring anomalies. Line charts now display notifications when QuickSight detects an anomaly, key driver, or forecasting opportunity. For more information, see Detecting outliers with ML-powered anomaly detection.

February 3, 2021

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. Current RLS datasets and deny-access configurations should continue to work as expected. For more information, see Using row-level security (RLS) to restrict access to a dataset.

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 OpenSearch

Amazon QuickSight now supports connecting to Amazon OpenSearch. For more information, see Using Amazon OpenSearch 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 IAM Identity Center 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 Table and pivot table formatting options in QuickSight.

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

Amazon 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 datasets 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 datasets. 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 Dataset 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 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

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

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.

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 Scheduling and 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 date filters.

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 text filters.

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 Creating maps and geospatial charts. 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 calculated fields. 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 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) with user-based rules 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 Aggregate functions. 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 an Amazon QuickSight dashboard. September 25, 2017

New feature

You can combine multiple filters using the And/Or operators. To learn more about filter groups, see Adding filter conditions (group filters) with AND 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 (IAM Identity Center) in Enterprise Edition. To learn more, see Using external identity federation and single sign-on 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 (IAM Identity Center) in Standard Edition. To learn more, see Using external identity federation and single sign-on 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 date filters.

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 from visuals.

March 21, 2017

New feature

You can now schedule data refreshes for SPICE datasets. To learn more, see Refreshing SPICE 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