DocumentationDiscussions
DocumentationDiscussions

Discussions

Ask a Question
Back to All

No data shown if Table style is selected on a dashboard.

I have following query:

select Last(errorCount) as Errors, Last(warningCount) as Warnings, Last(successCount) as Successes, Last(errorCount)+Last(warningCount)+Last(successCount) as Total
from stream where Has(successCount)

It shows expected data in the events window. When added to a dashboard, it shows data if Bar, Line, or Point style is selected. No data are displayed if I select Table style (which is my preferred choice since I'm interested in last values only).
Under DefTools I see no errors and following call to api

/api/data?q=select%20Last%28errorCount%29%20as%20Errors%2C%20Last%28warningCount%29%20as%20Warnings%2C%20Last%28successCount%29%20as%20Successes%2C%20Last%28errorCount%29%2BLast%28warningCount%29%2BLast%28successCount%29%20as%20Total%0D%0Afrom%20stream%20%0D%0Awhere%20%28%40Timestamp%20>%3D%20DateTime%28%272021-03-14T12%3A30%3A00.000Z%27%29%29%0D%0A%20%20and%20%28%40Timestamp%20<%20DateTime%28%272021-03-16T12%3A59%3A50.583Z%27%29%29%0D%0A%20%20and%20%28Has%28successCount%29%29%0D%0Afor%20window%2830m%29%0D%0A&signal=signal-279&timeoutMS=60000

returns this json:

{"Columns":["Errors","Warnings","Successes","Total"],"Rows":[[262,0,0,262]],"Statistics":{"ScannedEventCount":2495,"MatchingEventCount":0,"UncachedSegmentsScanned":false,"ElapsedMilliseconds":1.9800000000000002}}