Amazon QuickSight now allows you to easily create rich metrics and calculations for dashboards without having to craft complex SQL statements and precompute at the data source. QuickSight authors can now create calculated fields and table calculations to evaluate running sum of measures, partitioned by set of dimension in a specified sort order, or calculate percentage contribution of a measure to the total within the partitioned dimension. Similarly, authors can create custom fields that measure the difference or percentage difference between preceding or succeeding metrics, partitioned by a dimension. Authors can also rank metrics or sub-dimensions within the partitioned dimension. Other functions enable authors to measure sum, average, count, minimum/maximum, and display leading and lagging values by an offset of 1 over partitioned dimension. All these functions are available in both SPICE and non-SPICE datasets.

Starting today, you can pay your AWS invoices with any US ACH enabled bank account. Adding a bank account is easy. Simply go to the Payment Methods page on the AWS Billing Console and provide your bank account number, routing number, billing address, and your driver’s license number (for personal accounts) or tax identification number (for business accounts).

Amazon Redshift now enables short query acceleration by default to speed up execution of short-running queries such as reports, dashboards, and interactive analysis. Short query acceleration uses machine learning to provide higher performance, faster results, and better predictability of query execution times. 

AWS Elemental MediaLive is a broadcast-grade live video processing service. It lets you create high-quality live video streams for delivery to broadcast televisions and internet-connected multiscreen devices, like connected TVs, tablets, smartphones, and set-top boxes.

You can now use Amazon Redshift to directly query nested data in Apache Parquet, Apache ORC, JSON and Amazon Ion file formats stored in external tables in Amazon S3. Redshift Spectrum, a feature of Amazon Redshift, enables you to use your existing Business Intelligence tools and intuitive and powerful SQL extensions to analyze both scalar and nested data stored in your Amazon S3 data lake.

Starting today, C5d instances are available in the AWS US West (N. California), Asia Pacific (Seoul), Asia Pacific (Singapore), Europe (Frankfurt), and Europe (London) Regions. C5d instances were first introduced in May 2018 and delivers C5 instances equipped with local NVMe-based SSD block level storage physically connected to the host server. C5d instances provide high-performance block storage for applications that need access to high-speed, low latency local storage like video encoding, image manipulation and other forms of media processing. It will also benefit applications that need temporary storage of data, such as batch and log processing and applications that need caches and scratch files.  

Starting today, M5d instances are available in the AWS US West (N. California) and Europe (Frankfurt) Regions. M5d instances were first introduced in June 2018 and delivers M5 instances equipped with local NVMe-based SSD block level storage physically connected to the host server. M5d instances are ideal for workloads that require a balance of compute and memory resources along with high-speed, low latency local block storage including data logging and media processing.

You can now record analytics and messaging events directly using the Amazon Pinpoint Events Ingestion API. The API supports submission of events individually or in batches, updating user endpoints along with events generated by the user that can be used to record user events from your backend in addition to events recorded by your client application.

Starting today, AWS Secrets Manager enables you to delete secrets without requiring a recovery window. With this capability, you can now delete and recreate secrets, making it easier for you to manage automation jobs that create secrets.

You can now record changes to patch and association compliance statuses of AWS Systems Manager Managed Instances using AWS Config. Previously, you could only view the most recent status of a patch or association compliance for a managed instance. Now, with AWS Config, you can maintain a history of all changes to this data over time, and use it for your audit and compliance needs.