Bottom N Average

📊 Bottom N Average Function

🔍 Definition

The Bottom N Average function is used for:

➡️ Averaging (AVG) the values of a field
➡️ Retrieving N data with the SMALLEST Average value

👉 The opposite of Top N Average

⚙️ Parameter

1. 🎯 Field

Fields to be calculate the average

Example:

views
likes
sales

2. 🔢 Number of Record (N)

The amount of data to be displayed (Bottom N)

Example:

3 → 3 smallest values
5 → 5 smallest values

3. 🔀 Ordered (Y/N)

Y (Yes) → results are sorted (ascending / from smallest to largest)
N (No) → results are not guaranteed

📌 Recommended: use Y for clear results

📥 Input & 📤 Output

Input

Previous result data (usually after GroupBy)

Output
The output will contain:

All input fieldsNew fields:
- Field grouping with postfix_new
- Average result field

🧠 How it works

Sample Data:

    category	views
    ------------------
    A           100
    A           200
    B           300
    B           100
    C           50

Step 1: AVG per category

    category	average_views
    ----------------------
    A           150
    B           50
    C           50

Step 2: Bottom N (for example N=2)

    category_new    average_views
    -------------------------
    C               50
    A               150

🧪 Case Study

🎯 Case:

Showing 3 categories with the LOWEST total count views

🔄 Workflow

Source data
GroupBy →category
Bottom N Average:
- Field =views
- Number of Record =3
- Ordered =Y

📊 Output:

    category_new    average_views
    --------------------------
    Education       10,000
    Travel          15,000
    Music           20,000

💡 Important Note:

The useful output fields from this buffer function are the grouped fields and new fields. Add a Transformator (

) assembly afterward to select these fields.