Machines status real-time view

[pak]

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

[Greg_Deckler]

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:

https://support.office.com/en-us/article/Add-Visio-visualizations-to-Power-BI-reports-4F09BE62-F436-...

[pak]

Hi @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?