Forum Discussion
itshemant09
Microsoft
MicrosoftPrint 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(ise...
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.
itshemant09i 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")