Forum Discussion

Anonymous's avatar
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   ...
Need Help
Tutorial Requests
Anonymous's avatar
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's avatar
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's avatar
    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