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 48: Line 48:
 
! Calculated Field Name !! Formula !! Explanation
 
! 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> 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>
 
</center>

Revision as of 02:11, 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

A calculated field was 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