Avatar
Mobeen Tahir
Actividad total
24
Última actividad
Miembro desde
Siguiendo
0
Lo siguen
0

Comentarios

Actividad reciente de Mobeen Tahir
Ordenar por actividad reciente Actividad reciente Votos
  1. Comunidad
  2. Wrike Analyze
  3. [From Wrike] Advanced filters with offsets in formulas 🔎

Danielle Jones You can try this formula: With this formula for any active task and for any completed task that was completed prior to its due date you will get an empty cell. For any completed task...

  1. Comunidad
  2. Wrike Analyze
  3. [From Wrike] Advanced filters with offsets in formulas 🔎

Danielle Jones Would you like to exclude tasks that were completed on time only from the column (i.e. the cell should be blank) or exclude these tasks completely from the pivot table?

  1. Comunidad
  2. Wrike Analyze
  3. [From Wrike] Advanced filters with offsets in formulas 🔎

Hi Delaney,Since your time frames are custom we cannot use the "Break by" feature here. "Break by" allows us to split the data into different groupings of days, weeks, quarters and years but we can...

  1. Comunidad
  2. Wrike Analyze
  3. [From Wrike] Advanced filters with offsets in formulas 🔎

Danielle Jones Can you please try changing the condition from "<0" to "<1" and test? It is possible that you have tasks completed on the same day as their due date, which would give us a 0 for the ...

  1. Comunidad
  2. Wrike Analyze
  3. [From Wrike] Advanced filters with offsets in formulas 🔎

Danielle Jones Great question and Pietro Poli thanks for providing the solution. We indeed need to use a Date Difference here but if we want to count how many tasks in total were completed later th...

  1. Comunidad
  2. Wrike Analyze
  3. [From Wrike] Advanced filters with offsets in formulas 🔎

Pietro Poli This seems achievable. What I can recommend is using two filters for task dates and combined they will give you what you are looking for. See my example below:To filter for tasks that w...

  1. Comunidad
  2. Wrike Analyze
  3. Break-by Parameters & Combined Folder ID's

Hi Michael. The 'Folder Name' option will not work due to the reasons I mentioned above. 'Include data from Name' should work the way I mentioned. When you build the widget can you disable the 'Inc...

  1. Comunidad
  2. Wrike Analyze
  3. Break-by Parameters & Combined Folder ID's

Hi Michael Kreisbuch, happy Friday!You can definitely achieve this without using custom fields on each project, but it requires some configuration. In Wrike Analyze we can only display two levels o...

  1. Comunidad
  2. Wrike Analyze
  3. [From Wrike] Advanced filters with offsets in formulas 🔎

Kevin Thalacker great to hear that. Excluding "Today" from the count is a perfect use case for advanced filtering with offset.

  1. Comunidad
  2. Wrike Analyze
  3. [From Wrike] Using the ALL() function to build custom formulas

Hi Sarah Dungey, this formula can be used in any of the examples mentioned above. It can also be used in a custom field. If you have a use case where you'd need to use ALL () to override any custom...




Kudos

Label User name User email User type Date | Link