Filtering on No value (NULL) on FoO Chart Workshop

Ask the Community
,
1

Hello,

I face an issue on 2D or 3D Aggregations TS Function (FoO) To display NULL value , I’m using a defaultValue = “No Value” (string format) :

else if (time === 'Week') {
            const x = await objects
                .groupBy(val => val.plantTourStartReportingDate.byWeek())
                .segmentBy(val => val[xaxis].topValues({ defaultValue: 'No Value' }))                 
                .count();
            return (x);

So my Filter Variable on Workshop will try to find with Exact Match the string value “No Value” , without result.

What I want is to be able to display Null value on FoO and then be able to filter on it ,

Thanks for your help/support !

2

You should validate that your code returns what you expect it to return. You can call this function in Authoring on your data and see if it actually returns a No Value dimension column.

if it is correct, then you should check both the inputs you are passing into the function from workshop, and then how you filter the result of the function.

Once we know which piece is broken, we can further assist you in debugging this

3

Here my filter is in Exact Match method on “No Value” Text string :

{
“or”: {
“filters”: [
{
“exactMatch”: {
“terms”: [
“No Value”
],
“propertyId”: “changeover_target_size”
},
“type”: “exactMatch”
}
]
},
“type”: “or”
}

Thats the issue in my function I wouldlike to replace defaultValue : “No value” with NULL ? but not in string format. If yes , how can I do it ?

Thanks