topic Re: Suppressing NULL values in Insight Advisor Chat in Insight Advisor

Suppressing NULL values in Insight Advisor Chat

Vibhav_Shankar — Wed, 07 Sep 2022 11:34:51 GMT

Hello All,

Is there any to suppress null values in the Insight Advisor chat analysis ?

I ask IAC "what is my branch wise sales" the analysis also provides me sales which are not associated to any branch, which I don't want.

Anyway in which I can suppress the null values or perhaps reframe my question ?

Vibhav

Re: Suppressing NULL values in Insight Advisor Chat

pover — Tue, 11 Oct 2022 19:50:17 GMT

You can filter out the values by adjusting your data model to replace null values with a string value, like 'No Branch' and then ask a question like "sales branch except no branch".

If the branch fields values don't change, you can also add a synonym to the Vocabulary section that is the same name as the field and pre-select all non-null values.

Re: Suppressing NULL values in Insight Advisor Chat

Nasser_Bumpus — Wed, 26 Oct 2022 17:17:45 GMT

IAC is going to return the sales aligned to a NULL branch because that is how it is reflected in the data model. The methods listed above to resolve are correct:

In the data model, replace NULL values.
In the business logic, create a synonym and only include non-NULL from your selection.