Floor plan with motion sensors

[tijn167]

Hey guys,

Currently i'm working on a project which needs to show the occupancy of different rooms in an office. To do this i've tried out some arduinos with motion sensors. The data is send to Azure which then processed by streaming analytics. I wanted to send this to PowerBI and display it in a floor map. I've created a interactive floor map with synoptic.  
The only data I send to powerBI are: roomId(int) and roomOccupied(int, 0 = not occupied & 1 = occupied). But it seems that powerbi counts all these values and that's not what I want. I just want per roomId the fact if its occupied or not and with that info I want to change the color of the room to red or green

Already followed many tuts but nothing seems to work.

Anyone who can help me?

Thanks in advance

[v-yulgu-msft]

Hi @tijn167,

You can add roomId into Category section and add roomOccupied into Measure section. The roomOccupied will be aggregiated automatically, it is not allowed to change this default behavior.

Then, set state as below so that different rooms will be filled with different colors based on its occupied state.

Reference: Visual Awesomeness Unlocked - Using the Synoptic Panel

Best regards,
Yuliana Gu

[mura]

I am facing to the same problem.

And I found this forum.
It will be aggregiated automatically, so what should I do?
I'm trying to make appropriate date on Streming analytics SQL.
I haven't succeeded yet.

How can I make the Appropriate data?

[mura]

I am facing to the same problem.

And I found this forum.
It will be aggregiated automatically, so what should I do?
I'm trying to make appropriate date on Streming analytics SQL.
I haven't succeeded yet.

How can I make the Appropriate data?

[tijn167]

Hey, thanks for the reply.

It still seems that it's not working properly.

For your info: i'm using a streaming dataset, i don't know if it's compatible with what I want?

Here is screenshot of how it looks now: 

https://imgur.com/a/sgRAX

[v-yulgu-msft]

Hi @tijn167,

Could you provide the screenshot of output dataset? In your dataset, is RoomID a unique value?

Regards,
Yuliana Gu

[tijn167]

The roomid is unique

Every room has an iot-device which sends this to azure which forwards it directly to powerBI>

The output:

[

{

"roomid" : 1,

"roomoccupied" : 0 or 1 

}

]

Thanks