...
0:00 difference between local and CJ’s
3:30 recreation of delivered STL exports and filters as Library Export
5:30 old modifying local filters and exports and how that compares to the new query libraries
11:00 option to restrict permissions in library exports
12:00 toggling which groups are available
12:25 extended exports
16:00 new nomenclature can be a stumbling block
18:40 can build your own personal query libraries
19:25 configure in name of exports
20:30 can you make a deliminated export split out into multiple columns?
20:45 no, one export = 1 column, but can duplicate and use rank 1, rank 2, etcetera
22:22 schools 1-5 are included in the library exports
23:30 explanation most common related bases
Form Responses
27:00 effectiveness of yield events: connecting the form response to application and person
35:55 reports versus queries for counting mixing scopes
35:50 aggregate subquery exports counts final join
39:00 nesting subquery filters
41:00 total event registrations
45:00 independent subquery comparisons
49:00 comparison of app dates and event dates
--still has one more hour of time with Tristan--