Top N Sum

📊 Top N Sum Function

🔍 Definition

This function is used to:

➡️ Sum the values of a field
➡️ Then take the N data with the largest total value

In other words:

    Aggregate + Automatic Ranking (Top N based on SUM)

⚙️ Parameter

1. 🎯 Field

Fields to be summed

Example:

views
likes
sales

2. 🔢 Number of Record (N)

The amount of data you want to display
Example:
- 5 → Top 5
- 10 → Top 10

3. 🔀 Ordered (Y/N)

Y (Yes) → results are sorted (descending by sum)
N (No) → results are not guaranteed

📌 Recommendation: use Y for clear results (Largest top)

📥 Input & 📤 Output

Input

Previous result data (usually after GroupBy)

Output
The output will contain:

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

🧠 How it works

For example data:

    category        views
    ---------------------
    Music           100
    Music           200
    Gaming          300
    Gaming          100

After the process:

1. SUM per category

    category        sum_views
    --------------------------
    Music           300
    Gaming          400

2. Top N (for example N=1)

    category_new    sum_views
    -------------------------
    Gaming          400

🧪 Case Study Examples

🎯 Case:

Displays the Top 3 YouTube categories with the most total views

🔄 Workflow

Source → data YouTube
GroupBy → category
Top N Sum:
- Field = views
- Number of Record = 3
- Ordered = Y

📊 Output:

    category_new	sum_views
    -----------------------------
    Music               1,000,000
    Gaming              900,000
    News                850,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.