Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a column in db status.
Status:
Load*Inline [S.N,Status
1,Open
2,Closed
];
For the filter in the visualization, if any of the data open or closed not available ,I have to display as it is null without making any change in script.Because filter will show only open or closed.
Is it possible?
Thanks
Maybe create a new filter in ur sheet as follow:
aggr(if(len(trim(status))=0,'Null',Status),status)
or
aggr(if(isnull(status)=-1,'Null',Status),status)
For first one I commented open in my script and checked...It does not show null
Second one it does not work at all
You can't select null values in a visualization.
Best is to replace them in the script with a known value.
Changes in the front-end are usually slow.
Edit:
It is best practice to join your tables in the script, so that you can identify where the nulls are...
Kind Regards,
Dion
How did u comment it???
Status:
Load*Inline [S.N,Status
2,Closed
];
//1,Open
This is what I wrote ..I wanted to see closed and null in filter for open. I cannot do from script
Is it possible to send an example document?
We can help if we can see what you want to do.
Kind Regards,
Dion
This is not equal to saying not available !
Try as follow:
Status:
Load*Inline [S.N,Status
2,Closed
1,
];
and then try the expressions.
This is a real use case of "Status not available"
I commented to check....I cannot do anything from script...I have to show forcefully null to open or closed if database does not have it.
Yes I know;
but to check this, u have to do as I told u;
if there is no status in ur db it translates to this :
Load*Inline [S.N,Status
2,Closed
1,
];
not to :
Load*Inline [S.N,Status
1,Open
];
//2,Closed