Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone tell me how to filter the data that is empty please, clicking on an empty cell does nothing
If ESTATUS is a dimension you could eliminate Null values in your load script by loading it as:
, if(IsNull(ESTATUS), 'No Status', ESTATUS) as ESTATUS
Then you could filter on 'No Status' within your chart.
Check here?
User NullASValue as one of the ways to handle. Like
NULLASVALUE Field1, Field2, Field3;
SET NullValue = '<NoData>';
Your Actual Load Script.
Then when you display the fields as Listbox you should see NoData where ever there are nulls.