Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Summary Statistics for Tableau Public #5

Open
gompertzmakeham opened this issue Mar 12, 2019 · 0 comments
Open

Summary Statistics for Tableau Public #5

gompertzmakeham opened this issue Mar 12, 2019 · 0 comments
Assignees
Labels
enhancement New feature or request

Comments

@gompertzmakeham
Copy link
Owner

For both privacy and performance when publishing to Tableau Public the hazard rates need to be aggregated to:

  • Fiscal year.
  • Age in years.
  • Biological Sex.
  • Rate measure.

Each record must at least contain:

  • Identifier and description of the specific rate measure.
  • Identifier, description, lower and upper lifespan summed value of the denominator of the rate measure.
  • Identifier, description, lower and upper lifespan summed value of the numerator of the rate measure.
  • Number of persons in the sample represented by the record.
  • Summed squared sampling discount of the numerator and denominator.
@gompertzmakeham gompertzmakeham added the enhancement New feature or request label Mar 12, 2019
@gompertzmakeham gompertzmakeham self-assigned this Mar 12, 2019
gompertzmakeham added a commit that referenced this issue Mar 25, 2019
As a stop gap for #5 to make some aggregate data publicly available calculate statistics in a Tableau aggregate extract. Eventually this will have to be pushed down to the underlying database, for performance and for better accuracy in the calculation of standard errors; which currently does not account for within person correlations between the shortest and longest lifespan rates.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant