ISSS608 2017 T3 Assign BI HE Question
Q1 Characterize the past and most recent situation with respect to chemical contamination in the Boonsong Lekagul waterways. Do you see any trends of possible interest in this investigation?
Method
The line graph is used to display the trend of each indicator. Set up the axis as dual axis for real time waterway data and monthly average data. And synchronize the axis for two lines.
For the second part of the graph, the bar chart can be used to show the change of difference from monthly average. The setting for columns and rows is as below.
The filter for measure and location provides user to observe the trend for each indicator in each location.
Insight
For each of the indicator, the change ratio can be observed from the graph below.