ut-effectiveness / utDataStoR

https://ut-effectiveness.github.io/utDataStoR/
Other
0 stars 0 forks source link

Add fte_groups.sql to utDataStoR #21

Open andreabringhurst opened 3 months ago

andreabringhurst commented 3 months ago

I'm requesting we add a fte_groups.sql to utDataStoR. This would mirror what we are doing for Headcount in utDataStoR and will mirror what we are doing in utMetrics with FTE there. utMetrics fte.sql can be found here: https://github.com/ut-effectiveness/utMetrics/blob/dev_branch_main/inst/sql/fte.sql The utMetrics fte.sql would be a good starting point. Then any additions or changes can be moved into utMetrics once in utDataStoR.

andreabringhurst commented 1 week ago

This issue is waiting for the next enhancements to utDataStoR. This sql would need to mirror the headcount_groups.sql. Reviewing the code for utMetrics would be a good starting point, as would reviewing the headcount_groups.sql. Any new fields added that aren't in the current groups vignette (https://ut-effectiveness.github.io/utDataStoR/articles/groups.html) would need to be added to the groups vignette.