Reaggregation scenarios in practice
We provide real world scenarios for using flexible aggregation in ThoughtSpot.
The following scenarios showcase the use of the
group_aggregate function in the real world.
We provide them to demonstrate to you how the function works, and the scenarios where it proved useful.
Best practices for flexible aggregations
group_aggregate function enables you to calculate a result at a specific aggregation level, and then returns it at a different aggregation level.
For this reaggregation result to return correctly, follow these syntax guidelines:
group_aggregatein an aggregate function, such as
The wrapping function must be the immediate preceding function, such as