Helper Match Counts

Choose one helper column and count how many dataset rows match each helper value across one or more datasets.

Back to Dashboard Upload Helper

Build Count Query

Optional Sub-classification

Uses all Level 1 values corresponding to each main helper-column value.
Uses all Level 2 values corresponding to the selected main column and Level 1 combination.

Working Numbers uses a stored set date. Provisioning and Disconnection use a shared Month, Date Range, or FY period.

Sub-classification works as helper-column expansion, not single-value filtering. The preview will show real combinations found in the helper file.

Detected Columns

Helper columns

Choose a helper file to load its columns.

Working Numbers columns

BA EXG SSA PLAN EMAIL CIRCLE OLT_IP CUST_ADD OLT_NAME PHONE_NO CUST_NAME INST_DATE MOBILE_NO OLT_VENDOR SERVICE_TYPE ONT_ACQUISITION_TYPE

Provisioning columns

SSA DATED CIRCLE OLT_IP TEL_NUM EXCHANGE OLT_OWNER MAINT_FRAN CRM_ORDER_ID SERVICE_TYPE

Disconnection columns

SSA DATED CIRCLE OLT_IP TEL_NUM EXCHANGE OLT_OWNER MAINT_FRAN CRM_ORDER_ID SERVICE_TYPE ORDER_SUB_TYPE

Summary

Run a preview to see helper-entry and dataset match totals.

Count Preview

Run a preview to see counts for each helper entry across the selected datasets.