TOP or LATEST function

[mrobson]

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.

[J_Kroehnert]

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)

[kent_westerholm]

I have exactly the same problem. I need to show the measured electrical current of a device. Any workarounds?

[fbcideas_migusr]

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)

[fathomson]

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.