Run to view results
Run to view results
Run to view results
Date Range
Past 7 days
Client
All
Sku
All
Order Status
All
Response Code
All
Run to view results
Run to view results
Title
Value
-
Title
Value
-
Title
Value
-
Run to view results
Run to view results
Run to view results
# Sku drilldown - group by client and sku
# Restore previous behavior without empty-DataFrame fallback or headers
if df_filtered.empty:
print("No data available for the selected filters.")
else:
drilldown = df_filtered.groupby(['client_name', 'sku']).agg(
total_orders=('order_id', 'count'),
Success=('status', lambda x: (x == 'SUCCESS').sum()),
Pending=('status', lambda x: (x == 'PENDING').sum()),
Processing=('status', lambda x: (x == 'PROCESSING').sum()),
Failed=('status', lambda x: (x == 'FAILED').sum()),
Rejected=('status', lambda x: (x == 'REJECTED').sum())
).reset_index()
drilldown = drilldown.sort_values(by=['client_name', 'sku'], ascending=[True, True])
drilldown
Run to view results
# Response-code drilldown grouped by client and sku (using canonical categories)
if df_filtered.empty:
print("No data available for the selected filters.")
else:
# Build aggregation dict with canonical categories
agg_dict = {'total_orders': ('order_id', 'count')}
for category in RESPONSE_CODE_COLUMN_ORDER:
agg_dict[category] = ('response_category', lambda x, c=category: (x == c).sum())
drilldown_codes = df_filtered.groupby(['client_name', 'sku']).agg(**agg_dict).reset_index()
# Ensure column order: client_name, sku, total_orders, then response categories in order
column_order = ['client_name', 'sku', 'total_orders'] + RESPONSE_CODE_COLUMN_ORDER
drilldown_codes = drilldown_codes[column_order]
drilldown_codes = drilldown_codes.sort_values(by=['client_name', 'sku'], ascending=[True, True])
drilldown_codes
Run to view results
# Response-code drilldown grouped by SKU only (without client_name)
if df_filtered.empty:
print("No data available for the selected filters.")
else:
# Build aggregation dict with canonical categories
agg_dict = {'total_orders': ('order_id', 'count')}
for category in RESPONSE_CODE_COLUMN_ORDER:
agg_dict[category] = ('response_category', lambda x, c=category: (x == c).sum())
drilldown_codes_by_sku = df_filtered.groupby(['sku']).agg(**agg_dict).reset_index()
# Ensure column order: sku, total_orders, then response categories in order
column_order = ['sku', 'total_orders'] + RESPONSE_CODE_COLUMN_ORDER
drilldown_codes_by_sku = drilldown_codes_by_sku[column_order]
drilldown_codes_by_sku = drilldown_codes_by_sku.sort_values(by=['total_orders'], ascending=False)
drilldown_codes_by_sku
Run to view results