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.
