Difference between revisions of "IS428 AY2019-20T1 Assign Sean Chai Shong Hee Q2"
Jump to navigation
Jump to search
Line 39: | Line 39: | ||
== Question 2 == | == Question 2 == | ||
+ | |||
+ | === Calculated field: Average value of radiation by neighbourhood per day === | ||
+ | |||
+ | A calculated field was created during the data preparation phase: | ||
+ | <center> | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! Calculated Field Name !! Formula !! Explanation | ||
+ | |- | ||
+ | | Average value of radiation by neighbourhood per day || <b>{FIXED [Nbrhood], date([Timestamp]):avg([Value])} </b> || Returns the average radiation value for each neighbourhood for each day | ||
+ | |} | ||
+ | </center> |
Revision as of 02:09, 13 October 2019
Mini Case Challenge 2: Visualising Radiation Measurements in St. Himark
This section will answer questions for Mini Case 2
Question 2
Calculated field: Average value of radiation by neighbourhood per day
A calculated field was created during the data preparation phase:
Calculated Field Name | Formula | Explanation |
---|---|---|
Average value of radiation by neighbourhood per day | {FIXED [Nbrhood], date([Timestamp]):avg([Value])} | Returns the average radiation value for each neighbourhood for each day |