Exercise 2: Organise your data
Task 1: Hide/Unhide fields
This task helps you to clean up unnecessary fields in your model.
- From the left pane select the Model
10. Under the FIELDS section, select Date Table then list all the fields to examine which ones
we do not need for our report. For simplicity, we will hide all the fiscal date data.
11. When you hover the mouse on these fields, notice that there is an eye icon on the right,
click on that icon, it helps you to hide or unhide the fields. The result will look like this:
12. Repeat the steps for ISO date data
Task 2: Data Type Format
- Under the FIELDS section, Locate to % Female and % Male measure under General
Measures, and your YoY% measure under Time Analysis. Make sure they have Percentage
format, decimal number is suggested at 2
14. Under the FIELDS section, locate to Date field under Date Table, make sure it has a short
date format
