Forum Discussion

sreeparam's avatar
sreeparam
New Member
10 years ago

Timeline graph for Stream Analytics for the past one hour

I have the below query to show the Temperature of the device by timeline in stream analytics using live data   SELECT DeviceId,DeviceFields.Temperature as Temperature,System.Timestamp AS time INT...
Need Help
Enrico's avatar
Enrico
Frequent Visitor
10 years ago

The Q&A field is nice, but does not help to set a timeline to a dashboard. And thats mandatory. We are also using ASA and whant to show realtime data for the last 2 hours and thats not possible. Not in ASA and not in the Power BI web app. Why?

Expecho's avatar
Expecho
New Member
9 years ago

Bump, is there already a solution to this?

  • sirui_sun's avatar
    sirui_sun
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Currently, you should be able to use Q&A to accomplish this. Can you try the following steps:

     

    1. Go to the dashboard in question

    2. In the Q&A box, type "[value field] by [time feld] last one hour" - e.g. "temperature by time last one hour"

    3. Once you're satisfied with the visual produced by Q&A, press "pin visual" in the top right

    4. The visual will now be pinned to the dashboard, and will update in real-time

     

    Longer term, we're doing work to allow Azure Stream Analytics to output to the recently released streaming datasets. Streaming tiles, which are built atop streaming datasets, have native support for displaying data over a set time window. Look out for private preview of this sometime before the end of the year.