WEBVTT

1
00:00:00.000 --> 00:00:06.610
(No audio) 

2
00:00:06.620 --> 00:00:10.090
Speaker: We will cover an important feature 
of the table builder in the section

3
00:00:10.100 --> 00:00:13.910
saving and loading custom dimensions, 
and table definitions.

4
00:00:13.920 --> 00:00:18.300
To illustrate this feature, 
i'll first create a table.

5
00:00:18.310 --> 00:00:23.100
I'm selecting the survey of Doctorate recipients,

6
00:00:23.110 --> 00:00:30.240
(Silence)

7
00:00:30.250 --> 00:00:34.170
and adding the weighted count measure to the table.

8
00:00:36.520 --> 00:00:40.300
Next, I'm adding the job satisfaction dimension...

9
00:00:40.310 --> 00:00:46.560
(Silence)

10
00:00:46.570 --> 00:00:48.960
To the rules of the table. 

11
00:00:48.970 --> 00:00:54.840
Suppose the job satisfaction data has 
more detail than we need for our purposes.

12
00:00:54.850 --> 00:00:59.870
We simply care whether the respondents had positive 
or negative views of their job situations.

13
00:00:59.880 --> 00:01:08.550
For that reason we will combine the very satisfied 
and somewhat satisfied field labels into one,

14
00:01:08.560 --> 00:01:13.990
and do the same with the somewhat dissatisfied 
and very dissatisfied labels.

15
00:01:14.000 --> 00:01:21.880
We can accomplish that by creating a custom dimension 
from the original job satisfaction dimension.

16
00:01:22.760 --> 00:01:27.660
Let's navigate the dimension on the left side panel...

17
00:01:27.670 --> 00:01:30.390
(Silence)

18
00:01:30.400 --> 00:01:33.190
Click on the dimension name.

19
00:01:35.760 --> 00:01:40.080
This opens another slide-out with the field labels.

20
00:01:40.090 --> 00:01:46.540
Click on the customize button to begin 
creating custom categories for the dimension.

21
00:01:47.990 --> 00:01:50.080
First enter a name...

22
00:01:50.090 --> 00:01:53.820
(Silence)

23
00:01:53.830 --> 00:01:57.150
jobsat underscore custom for the custom dimension,

24
00:01:57.160 --> 00:02:01.590
Next, I want to add categories to the custom dimension. 

25
00:02:02.000 --> 00:02:05.120
To do that, click on the add categories button. 

26
00:02:05.130 --> 00:02:10.630
In the category label field, 
enter the name of the first category.

27
00:02:10.640 --> 00:02:14.320
My first category is Satisfied. 

28
00:02:14.330 --> 00:02:19.070
(Silence)

29
00:02:19.080 --> 00:02:25.920
and includes the field labels 
Somewhat Satisfied and Very Satisfied.

30
00:02:27.320 --> 00:02:31.790
Click on the check boxes next to these 
field labels and click on...

31
00:02:33.010 --> 00:02:35.200
Add category to create the first category.

32
00:02:35.210 --> 00:02:40.480
To create the second category, 
Click on the Add Categories button again, 

33
00:02:41.610 --> 00:02:45.230
And enter the category name Dissatisfied.

34
00:02:45.240 --> 00:02:53.960
(Silence)

35
00:02:53.970 --> 00:03:00.950
Click on the check boxes next to 
Somewhat Dissatisfied and Very Dissatisfied

36
00:03:02.100 --> 00:03:05.000
and click the add category button.

37
00:03:06.870 --> 00:03:14.000
we won't add logical skips to our (jumbled), 
logical skips of the different (jumbled) patterns in the survey questionnaire. 

38
00:03:14.010 --> 00:03:16.830
As an example, if a person is unemployed, 

39
00:03:16.840 --> 00:03:20.400
they would be asked to skip the question 
about job satisfaction.

40
00:03:20.410 --> 00:03:27.780
Now that we have the categories we want, 
Let's go ahead and click real custom, dimension.

41
00:03:27.800 --> 00:03:33.530
What this does, 
is make the custom dimension available 

42
00:03:33.540 --> 00:03:38.160
As a new variable in the left side panel.

43
00:03:38.170 --> 00:03:42.920
(Silence)

44
00:03:42.930 --> 00:03:48.170
The (jumbled) add the custom dimension to the rules of the table. 

45
00:03:48.180 --> 00:03:53.900
(Silence)

46
00:03:53.910 --> 00:03:59.000
Note that at this point if you reload the browser 
Or navigate to a different survey, 

47
00:03:59.010 --> 00:04:02.070
You will lose the custom dimension that you created. 

48
00:04:03.700 --> 00:04:07.000
To save this new custom dimension for future use,

49
00:04:07.010 --> 00:04:12.140
Click on the Save/Open button 
on the left side panel.

50
00:04:13.370 --> 00:04:16.310
This brings up a window with several options.

51
00:04:16.320 --> 00:04:24.920
Click on save dimension
to save your custom dimension to a downloaded file.

52
00:04:24.930 --> 00:04:29.570
You can also click on your custom dimensions link

53
00:04:29.580 --> 00:04:34.750
to see a preview of the custom dimensions
That are currently on the left side panel. 

54
00:04:36.410 --> 00:04:38.840
Let's go ahead and close this window. 

55
00:04:38.850 --> 00:04:41.540
Now, I am going to reload the browser.

56
00:04:41.550--> 00:04:46.200
(Silence)

57
00:04:46.210--> 00:04:49.120
Navigate to the job satisfaction dimension. 

58
00:04:49.130--> 00:04:52.440
(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)