Use ALL() in Wrike Analyze

TL;DR

ALL() lets part of a formula ignore filters or pivot table grouping, so you can compare a filtered value to an overall total, like each assignee’s task count as a percentage of all tasks.

• Overview
• Use ALL() in a Pivot Table
• What This Does
• More Ways to Use ALL()
• What’s Next?

Overview

ALL() lets you ignore dashboard filters, widget filters, or pivot table scope in part of a formula. Use it when you need to compare a filtered value with a total value.

You can find full syntax details in the Functions tab in the formula editor.

Use ALL() in a Pivot Table

Here’s one common example: show how many tasks each user has as a percentage of all tasks.

1. Create a pivot table.
2. Add Task Assignee as a column.

3. Add a value that counts tasks with COUNT([Task ID]).

   

4. Edit the value formula so it divides each assignee’s task count by the total task count.
5. In the denominator, use ALL() for Task Assignee so the formula counts tasks for all assignees, not just the current assignee.

Important

Use ALL() only in the part of the formula that should stay unfiltered.

Here is an example: COUNT([Task ID]) / (COUNT([Task ID]),ALL([Task Assignee] ))

6. In the value settings, change Data type to Percentage.

What This Does

The numerator shows tasks for each assignee.

The denominator ignores the assignee split and returns the total number of tasks for the whole team.

This gives you each person’s share of total tasks.

More Ways to Use ALL()

You can also use ALL() to compare:

• A user’s tracked time with total project time
• A user’s effort with total team effort
• A user’s completed tasks with total team completions
• A category’s cost with total cost across categories

What’s Next?

Formulas in Advanced Reporting