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
}
Shermaine Russell can you share some screenshots, so we can help you
Is there a solution available to this request? "Not excluding records with null values"?
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