Difference between revisions of "IS428 AY2019-20T1 Assign Chew Hui Ling Visualization"
Jump to navigation
Jump to search
Hlchew.2017 (talk | contribs) |
Hlchew.2017 (talk | contribs) |
||
Line 37: | Line 37: | ||
|- | |- | ||
| [[File:CH11-2019.jpg|300px]]|| In order to be more user-friendly, instead of having multiple charts that visualise the same variables such as time and value. I decided to create parameters such as variable type and activity type. This is to allow the user to choose what they want in just one chart. | | [[File:CH11-2019.jpg|300px]]|| In order to be more user-friendly, instead of having multiple charts that visualise the same variables such as time and value. I decided to create parameters such as variable type and activity type. This is to allow the user to choose what they want in just one chart. | ||
− | + | <br/> | |
For example, if the user wants to look at count instead of average. The user simply must click on count within the activity type. | For example, if the user wants to look at count instead of average. The user simply must click on count within the activity type. | ||
+ | <br/> | ||
<br/> | <br/> | ||
Code is as follows: | Code is as follows: | ||
+ | <br/> | ||
CASE [Activity Type] | CASE [Activity Type] | ||
− | + | <br/> | |
− | + | WHEN "Average" THEN Avg([Damage value]) | |
+ | <br/> | ||
+ | WHEN "Count" THEN COUNT([Damage value]) | ||
+ | <br/> | ||
END | END | ||
− | + | <br/> | |
|- | |- | ||
| [[File:CH12-2019.jpg|300px]]|| Just like before I decided to give more choices for the users where there would be a standard chart that is available, and the user can choose to put in the extra variable or not. | | [[File:CH12-2019.jpg|300px]]|| Just like before I decided to give more choices for the users where there would be a standard chart that is available, and the user can choose to put in the extra variable or not. | ||
− | + | <br/> | |
For example, if the user wants to add damage area for a more in-depth visualisation, the user can just click on damage area within choice and it will automatically be placed into the “row” field | For example, if the user wants to add damage area for a more in-depth visualisation, the user can just click on damage area within choice and it will automatically be placed into the “row” field | ||
+ | <br/> | ||
<br/> | <br/> | ||
Code is as follows: | Code is as follows: | ||
+ | <br/> | ||
CASE [Damage Area] | CASE [Damage Area] | ||
− | WHEN 'Damage Area' THEN [Damage area] | + | <br/> |
+ | WHEN 'Damage Area' | ||
+ | <br/> | ||
+ | THEN [Damage area] | ||
+ | <br/> | ||
ELSE '' | ELSE '' | ||
+ | <br/> | ||
END | END | ||
|- | |- | ||
| [[File:CH13-2019.jpg|300px]]|| If the user is more into visualisation, we have this feature that will plot the different variables chosen such as average damage value or count for shake intensity. It will then slowly plot to allow the user to view how is the reporting like during the 4 days. | | [[File:CH13-2019.jpg|300px]]|| If the user is more into visualisation, we have this feature that will plot the different variables chosen such as average damage value or count for shake intensity. It will then slowly plot to allow the user to view how is the reporting like during the 4 days. | ||
|- | |- | ||
− | | [[File:CH345-2019.jpg| | + | | [[File:CH345-2019.jpg|100px]]|| I have also created something for the tables so that it will allow the user to view the top 10 and bottom 10 counts immediately. This is to make it more user friendly because without it, they have to slowly find which are the highest and lowest values which makes it also very time consuming. Hence, with this it will change the color for the numbers that are top 10 and bottom 10. Special thing to note is that it is calculated based on table across then down so that it will calculate for the whole table instead of one column or row. |
<br/> | <br/> | ||
Code is as follows: | Code is as follows: | ||
− | + | <br/> | |
− | + | IF RANK_UNIQUE(sum([Number of Records]), 'desc') <= 10 | |
− | + | <br/> | |
+ | THEN "Highest Count" | ||
+ | <br/> | ||
+ | ELSEIF RANK_UNIQUE(sum([Number of Records]),'asc') <= 10 | ||
+ | <br/> | ||
+ | THEN "Lowest Count" | ||
+ | <br/> | ||
+ | ELSE"Neither" | ||
+ | <br/> | ||
END | END | ||
+ | <br/> | ||
|} | |} | ||
Latest revision as of 23:46, 14 October 2019
|
|
|
|
|
Interactive Visualization
Dashboard Explanation
The dashboard link is as follows: https://public.tableau.com/profile/chew.hui.ling#!/vizhome/Assignment_15710532491460/BackgroundPage
The following image shows the dashboard that I have created (missing background page). In each image, it shows a paragraph of what the image/figure/table is supposed to describe and the filters available.