Subject: How do I conditionally aggregate (count/sum/avg) by a specific Task Custom Text Field value

Devin Weiss

I’m working in a Custom Analytics Board widget (Wrike Analyze) and trying to better understand how Wrike formulas handle conditional aggregation.

My goal is to isolate tasks where a specific Task Custom Text Field equals a particular value (e.g., "2025 Courses") and then:

• Count the number of tasks with that value
• Or sum a numeric field for those tasks
• Or calculate the average of a numeric field (e.g., Timelog Time Spent in minutes)

In traditional spreadsheet terms, I’m essentially looking for the equivalent of:

• COUNTIF
• SUMIF
• AVERAGEIF

I’ve tried using IF() inside aggregation functions (e.g., wrapping logic inside AVG() or COUNT()), but I’ve run into syntax limitations in the Custom Analytics widget formula engine.

My questions are:

1. What is the correct Wrike Analyze formula pattern for conditionally aggregating based on a specific Task Custom Field Text value?
2. Is this done entirely within the formula editor using filters (Measured Value + Filter syntax)?
3. Are there limitations on using IF() or boolean logic inside aggregation functions in Custom Analytics widgets?

Any examples of properly structured formulas for this use case would be appreciated.

David Simmington

@Devin Weiss, give this structure a try in the formula editor:

CountIf
Count( ([Task ID], [Filter: <your text field> Equals '2025 Courses']) )

SumIf (numeric field)
Sum( ([<Numeric Field>], [Filter: <your text field> Equals '2025 Courses']) )

AverageIf (e.g., timelog minutes)
Avg( ([Timelog Time Spent (minutes)], [Filter: <your text field> Equals '2025 Courses']) )

1. add the measure (Task ID, Timelog Time Spent, your numeric field),
2. hover the criteria field, choose More → Filter
3. set Text filter → Equals → “2025 Courses”.

If the “2025 Courses” value lives in a Custom Field (generic custom-field model), Wrike Analyze often exposes custom fields via Task Custom Field Name + Task Custom Field Any Value / Numeric Value (rather than one dedicated field per custom field). In that case you usually need two filters inside the measured value:

Filter 1: Task Custom Field Name = '<Your Custom Field Name>'
Filter 2: Task Custom Field Any Value Equals '2025 Courses'