Posted On: Aug 8, 2018
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.
Additionally, Amazon QuickSight now supports aggregating date / time fields at the minute-level granularity. Dashboard readers can now drill down on date/time fields to the minute level in addition to year, month, week, day and hour.
These features are now available in all QuickSight regions - US East (N. Virginia and Ohio), US West (Oregon), EU (Ireland), and Asia Pacific (Singapore and Sydney), NRT Asia Pacific (Tokyo).
To learn more, visit QuickSight table calculations and minute level granularity.