(No audio)
Speaker: We will cover an important feature of the table builder in the section
saving and loading custom dimensions, and table definitions.
To illustrate this feature, i'll first create a table.
I'm selecting the survey of Doctorate recipients,
(Silence)
and adding the weighted count measure to the table.
Next, I'm adding the job satisfaction dimension...
(Silence)
To the rules of the table.
Suppose the job satisfaction data has more detail than we need for our purposes.
We simply care whether the respondents had positive or negative views of their job situations.
For that reason we will combine the very satisfied and somewhat satisfied field labels into one,
and do the same with the somewhat dissatisfied and very dissatisfied labels.
We can accomplish that by creating a custom dimension from the original job satisfaction dimension.
Let's navigate the dimension on the left side panel...
(Silence)
Click on the dimension name.
This opens another slide-out with the field labels.
Click on the customize button to begin creating custom categories for the dimension.
First enter a name...
(Silence)
jobsat underscore custom for the custom dimension,
Next, I want to add categories to the custom dimension.
To do that, click on the add categories button.
In the category label field, enter the name of the first category.
My first category is Satisfied.
(Silence)
and includes the field labels Somewhat Satisfied and Very Satisfied.
Click on the check boxes next to these field labels and click on...
Add category to create the first category.
To create the second category, Click on the Add Categories button again,
And enter the category name Dissatisfied.
(Silence)
Click on the check boxes next to Somewhat Dissatisfied and Very Dissatisfied
and click the add category button.
we won't add logical skips to our (jumbled), logical skips of the different (jumbled) patterns in the survey questionnaire.
As an example, if a person is unemployed,
they would be asked to skip the question about job satisfaction.
Now that we have the categories we want, Let's go ahead and click real custom, dimension.
What this does, is make the custom dimension available
As a new variable in the left side panel.
(Silence)
The (jumbled) add the custom dimension to the rules of the table.
(Silence)
Note that at this point if you reload the browser Or navigate to a different survey,
You will lose the custom dimension that you created.
To save this new custom dimension for future use,
Click on the Save/Open button on the left side panel.
This brings up a window with several options.
Click on save dimension to save your custom dimension to a downloaded file.
You can also click on your custom dimensions link
to see a preview of the custom dimensions That are currently on the left side panel.
Let's go ahead and close this window.
Now, I am going to reload the browser.
(Silence)
Navigate to the job satisfaction dimension.
(Silence) 59 00:04:52.450-> 00:04:57.890 And show you that the custom dimension is no longer present on the left side panel. 60 00:05:00.120-> 00:05:04.040 If I want to reuse the custom dimension that I previously saved, 61 00:05:04.050-> 00:05:10.650 all I need to do is go to the Save/Open button 62 00:05:10.660-> 00:05:13.100 And click on Open Dimension. 63 00:05:15.690-> 00:05:20.410 Navigate to... 64 00:05:20.420-> 00:27.66 The local folder that has the saved custom dimension and click Open. 65 00:05:29.800-> 00:05:35.500 You see a success message when your custom dimension is loaded to the left side panel. 66 00:05:35.510-> 00:05:42.580 Let's make the table again by adding the weighted count measure, and the custom dimensions that I just loaded. 67 00:05:42.590-> 00:05:57.930 (Silence) 68 00:05:57.940-> 00:06:03.100 To edit or delete a custom dimension, first make sure to remove it from the table, 69 00:06:04.940-> 00:06:08.970 then navigate to the custom dimension on the left side panel, 70 00:06:08.980-> 00:06:14.300 (Silence) 71 00:06:14.310-> 00:06:18.670 And click on Edit, next to the custom dimension. 72 00:06:18.680-> 00:06:23.220 This will bring up the custom dimension window. 73 00:06:23.230-> 00:06:26.740 Here you can edit the name, the category name, 74 00:06:26.750-> 00:06:32.390 add, update, delete categories, and also delete custom dimensions. 75 00:06:32.400-> 00:06:37.410 (Silence) 76 00:06:37.420-> 00:06:41.710 Next I'm going to show you how to save table definitions to a file 77 00:06:41.720-> 00:06:45.190 and later upload that file to reproduce the table, 78 00:06:45.200-> 00:06:49.100 perhaps for the purposes of continuing work in progress, 79 00:06:49.110-> 00:06:51.750 or to share your table definitions with others. 80 00:06:53.280-> 00:06:58.620 We will use the Save/Open button as we did before for the custom dimensions. 81 00:06:58.630-> 00:07:03.430 Let's clear this table and create a new table, 82 00:07:03.440-> 00:07:07.140 (Silent) 83 00:07:07.150-> 00:07:12.790 I'm adding the weighted count measure to the table, 83 00:07:12.800-> 00:07:19.030 Next I'm navigating to the location topic. 84 00:07:19.040-> 00:07:23.240 and adding the dimension Living in U.S. during reference week 85 00:07:23.250-> 00:07:29.510 And selecting only those residing in the U.S. during the reference week 86 00:07:31.930-> 00:07:33.780 to the column of the table. 87 00:07:33.790-> 00:07:39.760 (Silence) 88 00:07:39.770-> 00:07:43.780 Under the race and ethnicity topic, 89 00:07:43.790-> 00:07:48.580 We have the dimension Race and Ethnicity (Recorded for public use) 90 00:07:48.590-> 00:07:53.880 Let's go ahead and add this dimension To the rows of the table. 91 00:07:53.890-> 00:07:57.500 (Silence) 92 00:07:57.510-> 00:08:06.140 To save the table that I just created, Click on Save/Open button on the left side panel. 93 00:08:06.150-> 00:08:09.900 Next, click Save Table. 94 00:08:09.910-> 00:08:14.720 The system downloads a file on your personal device 95 00:08:14.730-> 00:08:18.680 with the definitions that allow the table to be reproduced at a later time. 96 00:08:18.690-> 00:08:18.680 The information in the downloaded file 97 00:08:18.690-> 00:08:22.100 The information in the downloaded file 98 00:08:22.110-> 00:08:27.580 includes your selections of measures, dimensions, including implied customized dimensions 99 00:08:27.590-> 00:08:31.940 And how the measures and dimensions are arranged in columns and rows. 100 00:08:31.950-> 00:08:38.370 The downloaded file has the default naming convention NCSES underscore collection 101 00:08:38.380-> 00:08:43.170 underscore the survey acronym, underscore the date and time stamp. 102 00:08:43.180-> 00:08:45.880 I am now going to clear the table, 103 00:08:45.890-> 00:08:52.820 so I can show you how to open the table definitions that have just been saved. 104 00:08:52.830-> 00:08:56.580 Once I click Clear Table, all left panel selections are cleared 105 00:08:56.590-> 00:08:58.270 and the table area is blank. 106 00:08:58.280-> 00:09:01.940 Now click on the Save/Open button, 107 00:09:01.950-> 00:09:06.300 and click on Open Table. 108 00:09:06.310-> 00:09:13.290 (Silence) 109 00:09:13.300-> 00:09:17.660 The system displays a dialogue window for you to select the file to upload. 110 00:09:17.670-> 00:09:25.250 Select the file... and click open. 111 00:09:25.260-> 00:09:31.130 The system verifies that the chosen date on file is the valid table definitions file 112 00:09:31.140-> 00:09:34.420 for the survey that is open in the table builder. 113 00:09:34.430-> 00:09:37.930 Once the system determines, the file is valid, 114 00:09:37.940-> 00:09:44.210 you see a pop up window with a preview of the measures and dimensions 115 00:09:46.200-> 00:09:51.030 click on open, and the system applies the table definition to the left side panel 116 00:09:51.040-> 00:09:54.080 and builds the table. 117 00:09:54.090-> 00:09:58.140 (Silent) 118 00:09:58.150-> 00:09:58.140 That concludes the demo of the Save/Open feature of the table builder. 119 00:09:58.150-> 00:10:09.470 (No audio)