Provide anomized reports of numerical needs assessments answers

[coderbyheart]

The submission to needs assessments should be provided in a summarized form so they can be used to create summary reports.

However: all free text inputs must not be published, this especially includes identifying information like email addresses and information about individuals and groups.

Reports should include

• an export of all submissions for an individual form maybe later
• aggregates per quarter, region, and country

Preparations:

• [x] add country information to regions
• [x] numerical inputs units need to be described so they can be converted into a default unit (e.g. Rice has two units: Euro Pallet and kg; must provide conversion from Euro Pallet to kg)

[coderbyheart]

I've analized the question from the current form that ask for numbers, and have multiple units. Some of them can be converted, but the presence of multiple units does not automatically mean that a conversion is possible.

For example: Washing Detergent has 1L bottle and 5k bag as units, however they cannot be directly converted to each other. In this case a super-unit (wash cycles) needs to be added, which allows to compare both units.

Unit conversion table

Below is the unit conversion table. Please see the first row which shows an example definition of a question that defines three units for Water, where the base unit is liters, and also provides two alternative units and the factor that converts the alternative unit to the base unit. The second row is another example that converts meters to centimeter and inches.

Name	Base unit	Alternative 1	In Base Units	Alternative 2	In Base Units
Water	Liter	5L bottle	5	333 ml can	0.333
Rope	meters	centimeters	0.01	inches	0.0254
Washing Detergent	wash cycles	1L bottle		5k bag
Rice	Kilogram	Euro pallets
Potatoes	Kilogram	Euro pallets
Onions	Kilogram	Euro pallets
Garlic	Kilogram	Euro pallets
Flour	Kilogram	Euro pallets
Salt	Kilogram	Euro pallets
Sugar	Kilogram	Euro pallets
Oil	Liter	Euro pallets
Milk	Liter	Euro pallets
Canned Tomatoes	Cans (№10 kitchen size)	Euro pallets
Canned Beans	Cans (№10 kitchen size)	Euro pallets
Canned Fish	Cans (№10 kitchen size)	Euro pallets
Sweetcorn	Cans (№10 kitchen size)	Euro pallets
Tea	Kilogram	Euro pallets		servings
Coffee	Kilogram	Euro pallets		servings

[coderbyheart]

Countries for regions used in the current form (some regions are a country):

ID	Name	Country
calais	Calais/Dunkirk	France
paris	Paris	France
chios	Chios	Greece
samos	Samos	Greece
lesvos	Lesvos	Greece
northernGreece	Thessaloniki/Northern Mainland Greece	Greece
southernGreece	Athens/Southern Mainland Greece	Greece
beirut	Beirut	Lebanon
bekka	Bekka Valley	Lebanon
saida	Saida	Lebanon
lebanon	Lebanon other	Lebanon
bosnia	Bosnia	Bosnia
serbia	Serbia	Serbia
ventimiglia	Ventimiglia	Italy
romania	Romania	Romania
poland	Poland	Poland
moldova	Moldova	Moldova
slovakia	Slovakia	Slovakia
hungary	Hungary	Hungary
croatia	Croatia	Croatia
other	Other	Other

[coderbyheart]

This has been implemented and pushed to production. Here is the example using the current needs assessment form:

• get a summary of all responses: https://storage.needs-assessment.distributeaid.dev/form/01G4X7XTMCD6MFHDT5KS7Z27GF/summary
• Only for a specific quarter (Q3): https://storage.needs-assessment.distributeaid.dev/form/01G4X7XTMCD6MFHDT5KS7Z27GF/summary?timeOfYear.quarter=q3
• Only for a specific region (Lesvos): https://storage.needs-assessment.distributeaid.dev/form/01G4X7XTMCD6MFHDT5KS7Z27GF/summary?basicInfo.region=lesvos
• Only for a specific country (Greece): https://storage.needs-assessment.distributeaid.dev/form/01G4X7XTMCD6MFHDT5KS7Z27GF/summary?basicInfo.region=countryCode:GR

All filters can be combined, e.g. create a summary for Q3 and Lesvos: https://storage.needs-assessment.distributeaid.dev/form/01G4X7XTMCD6MFHDT5KS7Z27GF/summary?basicInfo.region=lesvos&timeOfYear.quarter=q3