Databases Reference
In-Depth Information
The result will be the following screenshot:
Essentially, the
Class
function takes the individual result of an expression, in this
case the count of routes, and automatically creates the corresponding bin based on
the bin width specified.
The
Class
function only supports fixed bin widths.
We can take this further to use the
Class
function into a nested aggregation, by
having a new straight table chart with the following calculated dimension:
Aggr(Class(Count(DISTINCT [From - To State Code]), 100), [Carrier
Name])
Add the following expression:
Count(DISTINCT [Carrier Name])
The result will be as seen in the following screenshot:
