[4th viz] create user story / spec for 4th viz

[seinig]

Sankey diagram for donated boxes

Given a source base S, show the number of boxes that were donated to multiple destination bases D(n) within a time frame. In the best case, destination bases can be grouped by country --> use colours or patterns for that grouping instead of a additional node (see comments)

Due to different sources of data we need to seperate two sections:

• the top one using the data from the TRANSFER functionality,

• the bottom one the data from boxes in locations with DONATED being their default state. Location names will be the names of the destinations in the Sankey.

• FE can separate these two scenarios using 'types' of data to implement two different (hardcoded) flows and their decoration -- BE doesn't have to include 'source' for each 'target' -- flow from source to target becomes clear by type, in the current case

1. If via TRANSFERS: Moved out of Stock - Outgoing Shipments - Transferred Donations - Target
2. If via state 'donated': Moved out of Stock - Outgoing Shipments - Selfreported Donations - Target

(I'm not sure where Lost&Scrap belongs)

BE

• Lost
• Scrap
• Transfer
• moved to donated

FE

Nodes of the sankey in order from left to right (WIP):

1. "Moved out of stock" (100%)
2. "Lost" (terminates here) – "Scrap" (terminates here) – "Outgoing Shipments"
3. (Outgoing Shipments:) "Transfer of Donations" (data from shipment functionality) – "Self-Reported Donations" (data from base-locations status 'donated', that is from the 'moved out'-query)
4. (Transfer:) "Country/Region" – (Self-Reported:)N/A
5. (Country/Region:) "NGO/base" – (Self-Reported:) "NGO/base" printed as documented in the Location-name with status 'donated'

Grouping

• Box / Item

Filter

• Tag
• Product category
• product name
• No. of shipment: like time span, but oriented on events of outgoing transfers/moved-boxes

Mockup solving the question of country-grouping: via colour/pattern

Corresponding User Story: "I, as part of the fundraising team, try to fill our quarterly newsletter with content about our shipments in the last quarter/ half-year/ year to prove to our donors that we are using their donations in the right way."

Please share your thoughts in case you have feedback @aerinsol, also considering the labeling of the nodes.

[aerinsol]

Whew! Github Project notifications really don't work that well so it took me forever to find this issue even though I wanted to respond😅.

My quick feedback on the refined sankey @seinig would be to drop country as a grouping level for the sankey, and use color/pattern indicators for them instead. Then the shipments corresponding to a specific country (e.g. Greece) would all be gray, etc.

The diagram would clearly need to indicate as part of the title whether it's in boxes or items (I assume items generally makes more sense, but might be useful later for volume etc.)

I would probably edit the label naming somewhat, but I think we can do that as a last step.

[seinig]

Good to know, then i might link it to you via slack dm the next time 😅

• indicating by colour sounds perfect to me, then it should look something like edited above. In this case we could include a legend deciphering the colour coding, right? imo no priority though

• i agree concerning the info about boxes/items; in case this can be implemented as a grouping, this setting could be printed somewhere in the header, right @MaikNeubert ?

• yes, concerning names I'm open for improvements later