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 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.