---
title: "Combined Profile"
slug: "combined-profile"
updated: 2023-10-18T19:13:31Z
published: 2023-10-18T19:13:31Z
canonical: "docs.datajet.app/combined-profile"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Combined Profile

The combined profile report allows multiple profile result sets to be **joined into a single result set**. This allows column calculations, modelling and visualisations to be applied to multiple profiles at the same time and supports a single display of data which may not be connected by a common dimension. Profiles from **different tables** can be added to the same Combined Profile**.**

The following profile types can be added to a combined profile:

- Simple Profile with 1 dimension
- Multi-Function Profile with 1 dimension and 1 measure

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1697655360811.png)

Other Reports

- If all the rows that are to be displayed belong to a single dimension, the [Multi-Function Profile](/v1/docs/multi-function-profile) report, or [Profile report](/v1/docs/profile) may be used
- To create data-grids where rows do not belong to a single dimension, but where multiple measures need to be calculated, use the [Query Matrix](/v1/docs/query-matrix).

FiltersIf profiles in the combined profiler have been taken from different tables, applying a dataset (i.e., a filter) from a table that is not joined to **all tables** included in the profile will return a data error (*cannot make universe or resolve query*).  
  
If this error is seen do one of the following:  
  

- Right-Click in the result grid, and choose "Clear Data Set" to remove the invalid filter.
- [Join](/v1/docs/joins) tables as necessary
- Remove the unconnected profile row from the combined profiler.

## Report Structure

The report consists of the following sections:

- Control Frame
- Setup Grid

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1697655696520.png)

## Adding Profiles

To add a profile to the combined profiler:

1. Create a new profile report using one of the following methods:
  - **Right click** a discrete [table].[field] item in the Database Explorer and choose **Profile**![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1696602422554.png)****
  - **Drag a discrete [table].[field]** item into the **Workspace** and choose **Profile**![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1696601915212.png)****
  - **Open** a saved **simple** profile report from the **Reports tab** (a simple profile is a report with only 1 dimension)
2. Drag the open profile report and drop it onto the Setup Grid.  A profile row will be added to the Setup Grid:
3. Repeat steps 1-2 to add other profiles.

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1697655769376.png)

## Combination Mode

There are 2 combination modes available:

- first - only includes columns that are in the first profile
- all - include columns from all profiles in the list

By default the combination mode will be "**first**"

It is possible to hide the data generated by the first profile by selecting "Exclude First Row". The allows the first profile to be used for it's labels without needing to include it's data.

## Calculating the Report

To see the results from the report, click the run button:

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1697655821576.png)

To go back to design mode, do one of the following:

- Right-click and choose "Design Mode"
- Click the "Settings" button

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1697655903064.png)