Difference between revisions of "IS428 AY2019-20T1 Assign Sean Chai Shong Hee Q2"

From Visual Analytics for Business Intelligence
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 ===  
  
−
A calculated field was created during the data preparation phase:  
+
Two calculated fields were created during the data preparation phase:  
−
<center>
+
 
 
{| 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>
 
|}
 
|}
−
</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

Problem And Motivation

 

Data Preparation

 

Interactive Visualisation

 

Interesting Anomalies & Observations

 

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
Average radiation value by neighbourhood per day
{FIXED [Nbrhood], date([Timestamp]): avg([Value])}
Returns the average radiation levels of each neighbourhood for each day
Value > Average Value
if ([Value] > [Average radiation value by neighbourhood per day]) then 1 end
||
Returns 1 if current value > average value of neighbourhood sensor is currently in

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.

Retrieved from ‘https://wiki.smu.edu.sg/1920t1is428g1/index.php?title=IS428_AY2019-20T1_Assign_Sean_Chai_Shong_Hee_Q2&oldid=5121’