Understanding the Difference Between Two COUNT Formulas in Wrike

Avatar
Corey Adams

Hi Wrike Community,

I'm working on some reports in Wrike and came across two formulas that seem similar but yield different results. I'm hoping someone can help clarify the difference between them:

  1. Formula 1: (COUNT([Task ID]), [Months in Task Completion Date1])
  2. Formula 2: (COUNT([Task ID]), [Task Status Group])

From what I understand, both formulas are counting the number of tasks based on different criteria, but I'm not entirely sure how each one works or when to use one over the other.

Could anyone explain how these formulas differ in their functionality and in which scenarios each would be more appropriate to use?

Thanks in advance for your insights!

Best regards,
Corey

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
2 comentários
Avatar
Pietro Poli

Hi! The formulas you're referring count the numbers of task aggregating and summarizing data based on different criteria. 

Formula 1: (COUNT([Task ID]), [Months in Task Completion Date1])

  • COUNT([Task ID]): Counts the number of tasks.
  • [Months in Task Completion Date1]: Groups tasks based on the month in which they were completed.

Use Case:

  • Use this formula when you want to analyze task completion trends over time, specifically by months. It helps in understanding workload distribution across different months and can highlight seasonal trends or busy periods.

Formula 2: (COUNT([Task ID]), [Task Status Group])

  • COUNT([Task ID]): Counts the number of tasks.
  • [Task Status Group]: Groups tasks based on their status (e.g., "In Progress", "Completed", "On Hold", etc.).

Use Case:

  • Use this formula when you want to understand the distribution of tasks across different statuses. It helps in tracking progress, identifying bottlenecks (like tasks stuck in "On Hold" status), and monitoring overall task health.

Choosing Between the Formulas:

  1. Time Analysis: Use Formula 1 when your analysis is focused on understanding task completion over time (monthly). This is ideal for tracking trends and identifying seasonal patterns.

  2. Status Analysis: Use Formula 2 when you need to analyze the current state of tasks in terms of their status groups. This is useful for operational oversight and tracking progress against goals.

 

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Avatar
Corey Adams

Thank you so much!

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Understanding the Difference Between Two COUNT Formulas in Wrike
[this list is visible for admins and agents only]

Alto
Didn’t find what you were looking for? Write new post