Finding the min or max of a table

Find the Min or Max of a data set to quickly summarize large reports.

Finding the min or max of a table


Finding the min or max in a range is a useful operation when determining how to understand and further transform data. In Excel, you can use their built in Min or Max functions. SQL also has built in MIN and MAX functions.


In this example, we are looking for the distribution across quarters of top performance by sales rep. We use the Min/Max Object to find which quarter per sales rep was their personal best. Then, using the Row Lookup Object, we can tie that Max number to a Quarter label. From there, the Group By Object will aggregate the data into a distribution across all present Quarter labels.

Start automating with Parabola

Parabola is free to use for teams of any size. We also offer paid plans with additional features and support.