Difference between revisions of "IS428 AY2019-20T1 Assign Sean Chai Shong Hee Q2"
Jump to navigation
Jump to search
Line 42: | Line 42: | ||
=== Calculated field: Average value of radiation by neighbourhood per day === | === Calculated field: Average value of radiation by neighbourhood per day === | ||
− | + | Two calculated fields were created during the data preparation phase: | |
− | + | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
Line 49: | Line 49: | ||
|- | |- | ||
| <center> Average radiation value by neighbourhood per day </center> || <center> <b>{FIXED [Nbrhood], date([Timestamp]): avg([Value])} </b></center>|| <center> Returns the average radiation levels of each neighbourhood for each day </center> | | <center> Average radiation value by neighbourhood per day </center> || <center> <b>{FIXED [Nbrhood], date([Timestamp]): avg([Value])} </b></center>|| <center> Returns the average radiation levels of each neighbourhood for each day </center> | ||
+ | |||
+ | |- | ||
+ | | <center> Value > Average Value </center> || <center> <b> if ([Value] > [Average radiation value by neighbourhood per day]) then 1 | ||
+ | |||
+ | end </b></center>|| <center> Returns 1 if current value > average value of neighbourhood sensor is currently in </center> | ||
|} | |} | ||
− | </ | + | |
+ | The calculated field <b> Average Value </b> will help determine which value recorded is higher than the average recorded radiation value of the neighbourhood for that particular day. |
Revision as of 03:19, 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
Two calculated fields were created during the data preparation phase:
Calculated Field Name | Formula | Explanation |
---|---|---|
The calculated field Average Value will help determine which value recorded is higher than the average recorded radiation value of the neighbourhood for that particular day.