Forum Discussion
itshemant09
Microsoft
Jan 31, 2023Print custom message when there is no data in table return by kusto query
I am working on a dashboard, where in backend Kusto query are running and plot a graph on dashboard based on the results.
I am trying to print a custom message like,
| extend CustomColumn=iff(isempty(expectedExpiration),"Expiration data is not available for this ",expectedExpiration)
i tried isempty, isnull, isNaN function as well but I am not getting this custom message as an output.
Can you help in finding what is going wrong here or I am missing something?
2 Replies
Sort By
- wernerzirkelBrass Contributor
itshemant09 there's a workaround available here
https://stackoverflow.com/questions/61498237/return-null-instead-of-nothing-if-there-are-no-results-in-kusto
Not very nice of course. It would be easier for everybody if the dashboards would stop displaying this error-like red screen.- itshemant09
Microsoft
i tried this before posting this question here but didn't work. This is something that I tried from my own and it worked.
Tablename
| ,Your logic.
| project ExpectedExpiration,RemainingDays
| count
| project-rename c=Count
| extend colums=iff(c=="0","Yes","No")