A. Use Hyper Tableau Data Extracts
- Follow post to create Hyper file
B. Worksheet configuration
- Create new measure DISTINCTID
- Analysis Menu: Aggregated Measures -> Uncheck
- Analysis Menu: Stack Marks -> Off
- Drag Measure Names from Dimension to Filters Shelf -> Measure Names will show in the Filter Shelf -> Edit Filter -> To only show Effect Size and N.
- Drag Measure Values from Measures over Text on Mark Shelf -> Measure Values Shelf will appear with Effect Size and N
- Drag Measure Names to Column Shelf
- Drag DISTINCTID, Study, Grade range, Languages (bilingual) and Dominant cognitive benefits measured to Row Shelf
- Make sure DISTINCTID -> computing using -> Table (down)
C. Worksheet Result
D. Important Notes
- Measure Values and Measure Names need to work together to be effective.
- The configuration for Aggregate Measures and Stack Marks can be different for every worksheet.