Michael Robson on 23 Feb 2015 23:07:13
Existing aggregate functions are not always useful in a real-time dashboard. Take for example a dashboard that wants to track current speed of a connected car, or current call queue in a call-centre dashboard. At the moment, it's not possible to have a callout that achieves this as MIN, MAX, AVG would not make sense. A function such as TOP to display only the latest value should be made available. NOTE: This should not require a date field to implement but should simply display the latest value received.
- Comments (4)
RE: TOP or LATEST function
This has been requested more than 1.5 years ago and still not implemented. Sad to see that the 'realtime' dashboards have very limited applicability now.
RE: TOP or LATEST function
for now, seems this can be done only using the q&a feature like "show speed by measuredate last 10 minutes as line chart"
Definitly need this function to enhance displayed value, for example display on a gauge the min, max, avg, and current value (in this example, min, max, and avg would be calculated by stream analytics using sliding windows of for example 1h)
RE: TOP or LATEST function
I have exactly the same problem. I need to show the measured electrical current of a device. Any workarounds?
RE: TOP or LATEST function
Has anyone a workaround to implement showing the latest value of a real-time stream somehow? (We would have a datetime field, we tried to calculate a dateadd(s,-5) column in stream analytics and use AVG in combination with a filter on time to the datadd-Attribute in Power BI but only fixed target values are possible for the filter currently-so this doesnt work at this point of time too)