Skip to main content
phani_kumar
Gainsight Employee ⭐️⭐️
October 16, 2020

Null Values are not including in Reports when Excludes operation used for Picklist Field

  • October 16, 2020
  • 3 replies
  • 44 views

Hi.

Null values are excluding in the rpeort when we use the Excludes Operation for Picklist fields.

But we have a work around to accomplish this. Most of them already know how to ge the Null data, but posting it for the new once.

Ex: In the Object for one of the Picklist field we have (Active, InActive, Churn, None) values.

Screenshot:

And if we used the Excluded operator in filetr for this field, we are not getting null records count.

For Ex, I used the filter like this, Status Excludes Inactive, Churn. In this case I am getting only Active Records count.

Screenshot:

 

So if we want to include the Null records cout we have a work around for this, which is we have to create onemore filter witht the same field and use =Null. And in Advanced Logic use OR condition.

Screenshot:

 

Thanks.

    3 replies

    rakesh
    Gainsight Employee ⭐️
    Lets put your data to work!
    November 27, 2020

    Hi @phani_kumar 

    Most of these are related to how the underlying data sources work with picklist querying. Any differences you see is the differtence in behaviors of the data sources. To normalize that, what we are doing is explicitly asking if you want to include nulls or not in the filter itself. PFA a sneakpeak below and let me know if this works

     

     

    phani_kumar
    Gainsight Employee ⭐️⭐️
    November 27, 2020

    Hoo Super @rakesh. Thanks for giving this feature. When we will get this enabled in all Orgs.

    rakesh
    Gainsight Employee ⭐️
    Lets put your data to work!
    December 24, 2020

    March is the current target Phani!