---
title: "How do I filter reports to show distinct job counts?"
slug: "how-do-i-filter-reports-to-show-distinct-job-counts"
tags: ["Area - Reports", "Focus - Construction", "Focus - Service Replacement", "Role - Accountant", "Role - Admin", "Role - CSR Dispatch", "Type - Commercial", "Type - Residential"]
updated: 2026-10-16T03:08:40Z
published: 2026-10-16T03:08:40Z
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-11-09T11%3A20%3A51Z&se=2026-11-09T12%3A20%3A51Z&sr=c&sp=r&sig=BOtEwg54YSLm27Hi914WMLzuFWtRl1pJ7Oz2%2BvqK3YY%3D)
5. Wait for the report to update with the new column configuration.