Forum Discussion

Anonymous

Not applicable

7 years ago

Need help with selecting methods, advanced calculations

Hello, I have these (Azure) tables with these columns: Internal data (measured values from mine sensors in building, new data every 30 seconds): Temperatures, Humidities, Motions, Lights ...

Tutorial Requests

Anonymous

Not applicable

7 years ago

Hi Anonymous ,

Can you please share some sample data with same data structure for test?(you can create a pbix file with a part of records and upload to onedrive or google drive)

How to Get Your Question Answered Quickly

Notice: do mask on sensitive data.

Regards,

Xiaoxin Sheng

Anonymous
Not applicable
7 years ago
Anonymous

I forget that, sorry.

Here's link for my sample data:
https://stubask-my.sharepoint.com/:u:/g/personal/xvillar_stuba_sk/EeIVds1FaMFHjKY4MkcrejEBN9KsIIyZ9sIdpsX1VUUDig?e=SAChNJ

Most important table is "Summary table". I hope this will help you help me :)

Practical problem:
-> Assessing the subjective perception of temperature and other environmental conditions in the workplace

And I really don't know where to start or how to start there :(
- Anonymous
  Not applicable
  7 years ago
  HI Anonymous ,
  
  #1, In fact, I think you can add slicers to choose one date time range who has 'one variable changes obviously and other variables changes smooth' to confirm which variable can effect diff obviously.
  
  #2, You can add a static offset number of temperature/humidity diff, then use this number to compare with temp/humidity diff changes over time.
  
  For example: current temp/humidity diff and previous row, if it over offset, office window may opened on that datetime.
  
  Regards,
  
  Xiaoxin Sheng