Transposed data formats documentation

[bnygren]

Users are a bit confused by the transposed data formats and request a data dictionary, particularly that explains the matching of columns and calculation formulas

related: #654 #707 #712

see example of structure below:

Since the whole export is really text, not sure if the format col is needed. the description would be for any new variables and would show the formula for those that are summed for example.

Commas in labels that can cause problems can be replaced with a space for use in the csv file.

variable name	var name wide	var label wide	format	new	description
District	District	district	text
Dcode	DCode	dcode	integer
Cluster	Cluster	Cluster	text
Cluster Number	Cluster Number	clusternumber	integer
CCode	CCode	ccode	integer
Form Phase	Form Phase	formType	text
Source	Source	source	text
Creating User	Creating user	creatingUser	text
Day			integer	Yes	day of campaign index
NumberRemainingAbsent				Yes	NumberRemainingAbsent_day1 + NumberRemainingAbsent_day2 + NumberRemainingAbsent_day3
FoundVaccinatedAbsentReturnDuringCampaign				Yes	FoundVaccinatedAbsentReturnDuringCampaign_day1 + FoundVaccinatedAbsentReturnDuringCampaign_day2 + FoundVaccinatedAbsentReturnDuringCampaign_day3
TotalMissedDay1_3			integer	Yes	TotalMissedDay1_3_day1 + sum of TotalMissedDay1_3_day2 + sum of TotalMissedDay1_3_day3

[bnygren]

Per discussion 4-Dec with @DevSeg , we agreed to replace commas in the label description string with a pace to avoid issues with the csv column positioning. Thanks

[bnygren]

Hi @Eutit5 I know this was moved to review but where is the documentation? Is it in the wiki somewhere? thanks

[Eutit5]

@DevSeg

[DevSeg]

Hi @bnygren Do you mean the data dictionary that would be exported from the feature or do you want us to provide a wiki to address utilizing the exported documentation?

[bnygren]

Hi @DevSeg @Eutit5 I see it now. I didn't realize it was within the page itself. Thanks

[bnygren]

As this is now it seems to show the code for calculated fields, rather than explaining the fields created for the transposed export. That said I'm not sure this will be necessary. Reviewing the transposed data export field list as posted in #712, it seems the fields should be self explanatory. If we feel documentation is still necessary, the Support page may be a better location and the button for the Data Guide can then be removed.