Building a Big Number KPI in Apache Superset: Counting High-Value Orders (>10,000)

  

In modern data-driven systems, businesses don’t just look at raw data, they focus on key performance indicators (KPIs).

 

One of the most important KPIs in an e-commerce system is identifying high-value orders, which helps in:

 

·      Revenue segmentation

·      Identifying premium customers

·      Monitoring business growth quality (not just quantity)

·      Improving marketing targeting

 

In this example, we use an orders dataset and build a Big Number visualization in Apache Superset to count orders where the total amount exceeds 10,000.

 

This is a foundational pattern used in dashboards across product, finance, and analytics teams.

 

 

Step-by-Step Guide

Step 1: Start by logging into Superset and navigating to the Charts section from the top menu.

 

Click on + Chart, This opens the chart creation workflow.

 

Step 2: Configure Dataset.

 

Select Dataset, choose the dataset containing order information.

 

This dataset includes fields like:

 

·      order_id

·      user_id

·      order_status

·      total_amount

·      payment_status

 

Select 'Big Number' chart, Click on 'Create new chart' button.

 

It takes you to the chart configuration page.

 

Step 3: Define Metric (Core Logic)

We want to count orders, so set the metric as COUNT(*). Drag and drop the Count(*) metric under Query -> Metric section.

 

Step 4: Apply Business Filter

Now we introduce the key business rule, "Only include orders where total_amount > 10000".

 

In Superset UI:

 

·      Select column: total_amount

·      Condition: >

·      Value: 10000

 

This ensures we only analyze high-value transactions.

 

Click on ‘Create chart’ button, it executes the query and display the result.  

 

Step 5: Save the Chart

Click on Save button and provide the name as "High Value Orders (>10K)".

 

That's it, you are done.

 

 

Previous                                                    Next                                                    Home