Avatar
Mobeen Tahir
Activité totale
24
Dernière activité
Membre depuis
Abonnements
0
Abonnés
0

Aperçu des activités

Dernière activité effectuée par Mobeen Tahir
Avatar
Mobeen Tahir a ajouté un commentaire,
  1. Communauté
  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...

Avatar
Mobeen Tahir a ajouté un commentaire,
  1. Communauté
  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?

Avatar
Mobeen Tahir a ajouté un commentaire,
  1. Communauté
  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...

Avatar
Mobeen Tahir a ajouté un commentaire,
  1. Communauté
  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 ...

Avatar
Mobeen Tahir a ajouté un commentaire,
  1. Communauté
  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...

Avatar
Mobeen Tahir a ajouté un commentaire,
  1. Communauté
  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...

Avatar
Mobeen Tahir a créé une publication,
  1. Communauté
  2. Wrike Analyze

Hi, I’m Mobeen from the Wrike Professional Services team and today I’d like to show you how to build color-coded indicators in Wrike Analyze.   What is a color-coded indicator?   A color-coded indi...

Avatar
Mobeen Tahir a ajouté un commentaire,
  1. Communauté
  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...

Avatar
Mobeen Tahir a ajouté un commentaire,
  1. Communauté
  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...

Avatar
Mobeen Tahir a ajouté un commentaire,
  1. Communauté
  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.




Kudos

Label User name User email User type Date | Link