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
Do not use with conditional operators.
For example, the following expression does not reaggregate the data because the