...
form query: one row per event
form response: one row per registration
message: one row per email received
message track: one row per click/open
27:05 system: lookup tables, list of fields/prompts
count of times a particular prompt value is selected within records
Reporting Concepts I & II
Nov 11: Reporting #1
1:30 navigation
...
50:30 pie charts, geo maps
54:30 timeline
Nov 18 Reporting #2: Rebuilding High Value reports demo
1:00 Year-to-Date Application Report with percentage change
13:00 duplication of row filter/column filters
17:00 redundant date filters
22:30 nullif in formula
23:00 format percentage
28:00 format mask for row name when grouping
31:00 static content/section titles
31:20 adding citizenship section
33:30 race and ethnicity section
34:15 round key as an evergreen filter
36:00 multi-value fields (race)
39:20 double counting --disaggregate ‘2 or more’
45:45 Event Attendance
46:50 links out to specific events
51:45 using specific form response base for a specific event
Slate Captain CJ’s Deep Dive 9/17/2024
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--