---
title: "IProfile"
slug: "iprofile"
updated: 2025-07-18T16:18:40Z
published: 2025-07-18T16:18:40Z
canonical: "docs.datajet.app/iprofile"
---

> ## 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.

# IProfile

Creates an Index Profile Report

| Key | Value(s) | Description |
| --- | --- | --- |
| method | "IProfile" | Creates an Index Profile Report |
| baseSet{} |  | Optional. Base Filter |
| compositeView | true/false | Optional. Default = false. If true, a composite index will be calculated. |
| dataset{} | datasetObject{} | Optional. If provided, will be applied as Target Filter. |
| displayPrecision | N | Optional. Default =2 Precision to be used for the index calculation. |
| fields[] | [ "Table1.Field1" "Table1.Field2" "..." ] | Optional. One of either fields[] or template must be provided. List of fields to apply as dimension(s). All must be from the same table. |
| [forEach](/v1/docs/foreach){} |  |  |
| excludeNullsFromCombinedTotals | true/false | If true, ratio denominators will exclude nulls |
| includeEmptyTargetRows | true/false |  |
| limitRows | true/false |  |
| [saveAs](/v1/docs/saveas) |  |  |
| [secondaryProcess](/v1/docs/secondaryprocess){} |  |  |
| sortMode |  | 0 = default 1 = Ascending Label 2 = Descending Label 3 = Ascending Value 4 = Descending Value |
| sortColumn |  | Column number of column to sort by. For multi-dimensional profiles, all label columns have a sort column index of the number of dimesions in the profile. |
| template |  | Optional. If supplied, a template can be specified instead of a field list. |

{Explanation}

```json
{
  "method": "IProfile",
  "project": "DJDemo2023",
  "compositeView": false,
  "zeroCentric": false,
  "limitRows": 0,
  "includeEmptyIndexTargetRows": false,
  "displayPrecision": 2,
  "sortMode": 0,
  "sortColumn": -1,
  "fields": [
    {
      "type": "field",
      "name": "customer.region",
      "table": "customer",
      "valueFilter": []
    }
  ]
}
```