QC - Add MonthDay column

[leppott]

Is your feature request related to a problem? Please describe.
Add one new column to the QC csv file – a MonthDay text field as shown below. It needs to be a text field and have 2-digits for both month and day (e.g., 01/04 instead of 1/4), otherwise it won’t sort properly. This column serves as our left hand column in the pivot table. Right now we are asking users to create that field. It’d be a nice step to skip if possible

Describe the solution you'd like
During the QC step when add Month, Day, and Year columns add MonthDay.

Describe alternatives you've considered
Can add in Excel after the fact from the Month and Day columns but nicer to have it already added.

Additional context

[leppott]

1. Add to QC (regular and File versions).
2. Combine with date format from config.
3. Add column name and any other info to the config file.
4. Update the config file in its various locations in the package (e.g., Shiny).

[leppott]

MonthDay already exists in the config file.

ContData.env$myName.MoDa <- "MonthDay"

It is used in the stats operation.

Do not use a delimiter so always sorts correctly (as a number or character).

Text Editor (Notepad++)

Excel will drop the leading zeros and if thinks it is a date will add the current year. Since the file is a CSV cannot save the class (number vs. text vs. date).

Excel

[leppott]

Don't need to modify config file only the two QC scripts.

[leppott]

Added.

Excel

Text Editor (Notepad++)

[leppott]

Stats procedure is ok as it generates its own MonthDay. However, no stats are generated on MonthDay. Could be a future update.