Not excluding records with null values

Hello,

I am using Wrike Analyze to pull a pivot table of tasks that have a custom field filled out. But I have noticed that it will exclude some of the task records (specifically under pulling in the correlating project name) when that row is turned on in the pivot settings. So, if the task does not have a correlating project, it will exclude that record from the pivot. What I would like to do is have the project name field be blank so that the record stays. I specifically want to know if it is correlated to a project or not. I do not want to use the Folder/Project field. 

Is it possible to update the advanced settings for that field to include null values? I tried updating the advanced settings for the project name field to what I have below, but it did not include the additional records that are included if I turn that field off.  Thanks for your help!

Code I updated (what I added is in bold)

{
 "explicit": false,
 "multiSelection": true,
 "all": true,
 "includeNull": true
}

 

 

 

 

 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
2 comments

Shermaine Russell can you share some screenshots, so we can help you

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Hi Shermaine Russell, thank you for sharing this question with us. I have opened a ticket with our Support Team on your behalf so one of our experts can assist you with this. One of our agents will reach out to you very soon 👍
 
In the meantime, please don't hesitate to let us know if we can help with any other questions you might have. Thank you!

Juan Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Juan Wrike Team member Become a Wrike expert with Wrike Discover

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

Folllowing List for Post: Not excluding records with null values
[this list is visible for admins and agents only]

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