DealsSummary
Returns aggregated summary statistics for deals, including total count, converted values, and weighted values, optionally filtered by user, stage, status, or filter.
View-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Status | = |
| UserId | = |
| FilterId | = |
| StageId | = |
For example, the following queries are processed server-side:
SELECT * FROM DealsSummary WHERE UserId = 8230170
SELECT * FROM DealsSummary WHERE Status = 'open'
SELECT * FROM DealsSummary WHERE StageId = 1
SELECT * FROM DealsSummary WHERE FilterId = 1
Columns
| Name | Type | References | Description |
| TotalCount | Integer | Total number of deals included in the summary. | |
| Totalvalue | Double | Sum of all deal values converted to the default currency. | |
| TotalValueFormatted | String | Total converted deal value formatted as a currency display string. | |
| TotalWeightedValue | Double | Sum of all deal values weighted by their probability and converted to the default currency. | |
| TotalWeightedValueFormatted | String | Total weighted converted deal value formatted as a currency display string. | |
| ValuesTotal | String | JSON object containing total deal values broken down by currency. | |
| WeightedValuesTotal | String | JSON object containing probability-weighted deal values broken down by currency. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| FilterId | Integer | Filter Id. | |
| UserId | Integer | User Id. | |
| StageId | Integer | Stage Id. | |
| Status | String | Status. |