Looker Studio Function: Min Function

Category: Aggregation function

In Looker Studio, the MIN function is a fundamental aggregation tool that returns the smallest numeric value from a dataset. This function is invaluable for identifying outliers, establishing performance baselines, and conducting detailed data analyses.

Purpose of the Min Function

1. Data Distribution Analysis :By pinpointing the minimum values, the MIN function helps in understanding the spread and variability within your data, offering insights into the range of values present.

2. Customer Segmentation :  Identifying the lowest metrics, such as minimum purchase amounts, allows businesses to segment customers based on their least engagement or spending, aiding in targeted marketing strategies.

3. Decision Making : Knowing the minimum values in key performance indicators (KPIs) assists decision-makers in setting realistic benchmarks and identifying areas needing improvement.

Type of Calculation:

The MIN function performs an aggregation calculation, evaluating a set of numbers and returning the smallest value. It’s essential to note that MIN cannot process aggregated fields or the results of other aggregation functions .

Practical Use Cases:

1. Performance Benchmark : By identifying the minimum performance metrics, businesses can set lower bounds for acceptable performance and focus on areas requiring enhancement.

2. Customer Segmentation : Analyzing minimum purchase values helps in identifying low-engagement customers, enabling targeted strategies to increase their activity.

3. Time Series Analysis : In time series data, the MIN function can highlight the lowest values over specific periods, aiding in trend analysis and anomaly detection.

How Does the Min Function Work?
The MIN function scans a dataset and compares all numeric values. It identifies the smallest value and returns it as the result. This process is crucial for highlighting the lowest data points in analyses.

When Should We Use It?

Use the MIN function when you need to identify the smallest value in a dataset, such as determining the least sales in a period or the minimum response time in a system, to inform analysis and decision-making.

Example of MIN Function with Result

Scenario: Analyzing weekly sales data.

Data: Week 1: 200, Week 2: 150, Week 3: 180

Formula:
MIN(Sales)

Result:
150 (Week 2 had the lowest sales).

Basic Usage

MIN(Sales)

Column Usage

MIN(Column1, Column2, Column3)

Combining Min with Other Functions

You can combine MIN with other functions for more complex analyses. For example:

MIN(Sales)

This formula finds the minimum sales value and increases it by 10%.

Tips and Tricks

• • • Always ensure that the data passed to MIN is numeric.

    • Use MIN in combination with MAX to analyze the range of data.

    • Be cautious when using MIN with aggregated data; it may not return expected results.