ctsit / rcc.billing

Automated, data-driven service billing implemented on REDCap Custodian
https://ctsit.github.io/rcc.billing/
Apache License 2.0
0 stars 3 forks source link

Update `revenue_status_and_projections.qmd` to describe status of projects that should have been invoiced #168

Closed pbchase closed 1 year ago

pbchase commented 1 year ago

Update revenue_status_and_projections.qmd. Create a dataframe with the current status of every project that should have been invoiced. i.e., if a project was mature at the beginning of a month, include it in the report. In the dataframe add a column for each of these logical statuses. Set the status column to true for each status that is true, otherwise set it to false. Leave no NAs.

Summarize the above data into counts of each status. Add this summary table to revenue_status_and_projections.qmd before https://github.com/ctsit/rcc.billing/blob/597cd999144568d69ccdec2a8a60041efc427c16/report/revenue_status_and_projections.qmd#L147

Write the new dataframe as a CSV in ./output/ This file will be chucked during automated report runs, but will be available for review after any manual run.

pbchase commented 1 year ago

Addressed by PR #179