Help! How to design summary number for this case?

Got it. Unfortunately, there is not a native function in Domo that can produce the top N analysis that you are trying to accomplish. However, I believe you are able to achieve this by coding a Python script in the ETL that can dynamically adjust the summary number at the card level after filters have been applied. Please see the Python script below for an example:

# Import the domomagic package into the script
from domomagic import *

# Read data from inputs into a data frame
input1 = read_dataframe('NAME OF ETL TILE PRECEDING THIS PYTHON TILE')

# Function to calculate top N provinces based on parcel quantity
def calculate_top_n_provinces(df, N=5):

  # Group by province and calculate the total parcel quantity for each province

  province_totals = df.groupby('Province包裹数')['快递单号'].count().reset_index()

  province_totals.columns = ['Province包裹数', 'TotalParcels']



  # Sort by total parcel quantity in descending order and get the top N provinces

  top_n_provinces = province_totals.sort_values(by='TotalParcels', ascending=False).head(N)



  return top_n_provinces

# Function to calculate summary numbers for top N provinces
def calculate_summary_numbers(df, top_n_provinces):

  # Filter the input data frame to include only rows from the top N provinces

  filtered_df = df[df['Province包裹数'].isin(top_n_provinces['Province包裹数'])]



  # Calculate the summary number, which is the total parcel quantity for top N provinces

  summary_number = filtered_df['快递单号'].count()


    
  return summary_number

# Get the top 5 provinces based on parcel quantity
top_5_provinces = calculate_top_n_provinces(input1, N=5)

# Calculate the summary number for the top 5 provinces
summary_number = calculate_summary_numbers(input1, top_5_provinces)

# Add the summary number to the data frame for visualization purposes
input1['Top5省份包裹数'] = summary_number

# Write the data frame so it's available to the next action
write_dataframe(input1)

This logic should produce the dynamic calculation logic you are looking for in the summary number of this heat map card, even after when filters are applied.