Parabola
How it worksFeaturesExamplesUse CasesPricing
Y

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

Objective

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.

Solution

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.

Ready to get started?
Try it now for free, no credit card required