--- title: "How do I filter reports to show distinct job counts?" slug: "how-do-i-filter-reports-to-show-distinct-job-counts" updated: 2026-10-15T01:23:12Z published: 2026-10-15T01:23:12Z canonical: "help.servicetitan.com/how-do-i-filter-reports-to-show-distinct-job-counts" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.servicetitan.com/llms.txt > Use this file to discover all available pages before exploring further. # How do I filter reports to show distinct job counts? ## Problem When running a report, the report columns show duplicate job counts instead of unique job totals. ## Solution ### Set column configurations 1. Go to the report you want to filter for distinct job count. 2. Make sure the *Job Number* column is included in your report. 3. Scroll to the bottom of the report to the *Column Configuration* area. 4. Select **Count Distinct** from the dropdown options. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/how-do-i-filter-reports-to-show-distinct-job-counts-image-tf5wcbnv.png?sv=2026-02-06&spr=https&st=2026-10-31T00%3A43%3A16Z&se=2026-10-31T01%3A43%3A16Z&sr=c&sp=r&sig=6HtegEMo0xNhL1zfLah9HCvCIi9LIFWcgaH8PeEb6n4%3D) 5. Wait for the report to update with the new column configuration.