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 |
