cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tijn167 Frequent Visitor
Frequent Visitor

Floor plan with motion sensors

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

6 REPLIES 6
Community Support Team
Community Support Team

Re: Floor plan with motion sensors

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.

1.PNG

 

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

2.PNG

Reference: Visual Awesomeness Unlocked - Using the Synoptic Panel

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tijn167 Frequent Visitor
Frequent Visitor

Re: Floor plan with motion sensors

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

 

Community Support Team
Community Support Team

Re: Floor plan with motion sensors

Hi @tijn167,

 

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

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tijn167 Frequent Visitor
Frequent Visitor

Re: Floor plan with motion sensors

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
mura Frequent Visitor
Frequent Visitor

Re: Floor plan with motion sensors

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 Frequent Visitor
Frequent Visitor

Re: Floor plan with motion sensors

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?