Forum Discussion
Helper IIMachines status real-time view
Hello,
Is there a way to show a map of factory plant with actual state of, for example 4 machines.
I got information every 10 secounds that tells me what is the state of the each machine (0 as stand by, 1 as working).
Now i have few tiles with Machines title and values 1 or 0. But this view is not usefull.
What i would like to do is for example is to draw factory plant map and for every machine draw "lights" - green for work (1) and yellow for stand by (0).
I use Azure IoTHub -> StreamAnalytics -> PowerBI
| TIME | M1W | M2W | M3W | M4W |
| "2018-02-19T13:16:57.0000000" | 1 | 1 | 1 | 0 |
| "2018-02-19T13:17:07.0000000" | 1 | 0 | 1 | 0 |
| "2018-02-19T13:17:10.0000000" | 0 | 1 | 1 | 1 |
| "2018-02-19T13:17:13.0000000" | 0 | 0 | 1 | 1 |
Anyone knows how to do something like that? Is that even possible?
Best regard
pak
3 Replies
- Greg_Deckler
Community Champion
Yes, I would actually take a look at the Visio custom visual available for free in the store. You can draw whatever you like and then tie boxes to your data to make them change color based on the data. There is a good article here:
pakHi Greg_Deckler
I tried with Visio custom visual, but not like it is in the article the data i selected by different rows.
I want to take only last row (latest timestamp) and assign values from different columns to different elements in Visio visual. When i try to do this it doesn't work. It assign every collumn that i input to the same element even that i chose different one.
- pak
Hi all.
So I need to convert this table:
TIME M1W M2W M3W M4W "2018-02-19T13:16:57.0000000" 1 1 1 0 "2018-02-19T13:17:07.0000000" 1 0 1 0 "2018-02-19T13:17:10.0000000" 0 1 1 1 "2018-02-19T13:17:13.0000000" 0 0 1 1 To that table:
NAME STATUS M1W 0 M2W 0 M3W 1 M4W 1
The structure of the secound table should be same all the time. With every new message values in every row of column STATUS should be updated (values from first table from row with the latest timestamp should be pasted).I think i should do this in StreamAnalytics. Can anyone have idea how?
