Forum Discussion
Need help with selecting methods, advanced calculations
Anonymous
I forget that, sorry.
Here's link for my sample data:
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 :(
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