Created by Miki Yanagi, last modified by Corina C Larsen on Feb 22, 2021
HELP IS AT HAND!
Question, comment, critique? We are here to help and we strive to make our site a comprehensive, user friendly experience. Contact us at DARTS@maine.edu.
The fields list tends to get longer when you start creating your own measures or columns. You can create a new table to store your calculated fields to make them easier to use.
Create a Measure Table:
Issue Example: The field list on the original table is longer due to my calculated measures. I want to move all my measures to a new table.
Go to the Modeling tab and click New Table.
Name the table "Measures Table" and click the checkmark
From the Fields panel, click on one of the measures you created. Change from the Home table to "Measures Table".
You now see the measures have moved to the Measures Table.
Repeat step #3 to move other measures to the new table.
On the Measures Table, the Column field is created automatically. Right click the Column field and choose Hide.
You see all of the measures in one table, which make you easier to find measures for your visuals.
Hide fields:
Go to the Model Pane
Since the Acad_career table has been created, the model now has two ACAD__CAREER fields. This creates confusions, so ACAD_CAREER from the Census table should be invisible. Click the field and click button for "Is hidden" under Properties.
Now the ACAD_CAREER field from Census table has been hidden.