Difference between revisions of "IS428 AY2019-20T1 Assign Sean Chai Shong Hee Q2"
Jump to navigation
Jump to search
Line 48: | Line 48: | ||
! Calculated Field Name !! Formula !! Explanation | ! Calculated Field Name !! Formula !! Explanation | ||
|- | |- | ||
− | | <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> | + | | <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 that 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. | 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:27, 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.