Amazon QuickSight is excited to announce the launch of Common Sub-expression Elimination (CSE) – a performance optimization initiative for better query generation for SPICE datasets. The CSE improves QuickSight user experience through pushing down repeated use of complex expressions into intermediate tables hence simplify complex queries, such as for totals/subtotals, top bottom filter, conditional formatting, and “others” bucket for charts, etc. Through the CSE query optimization, customers would observe faster loading dashboards, especially for complex dashboards and time-consuming interactions. Currently, the CSE is released with SPICE datasets only. There is no customer configuration needed, the backend change will seamlessly apply to the QuickSight usage.
Source:: Amazon AWS