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
4 commenti

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

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

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!
0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Is there a solution available to this request? "Not excluding records with null values"?

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

Hi Persio De Luca, welcome to the forums 👋 I've just asked our Wrike Analyze specialists to reach out to you to discuss your use case; they will contact you separately 👍

Is there anything else the Community can help you with? 

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

Lisa 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]

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