...
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