Skip to content

Mismatch in calculation of collective.stats.contributionsAmountTimeSeries #8266

@pabloyoyoista

Description

@pabloyoyoista

Describe the bug

Since August, the values in all the 'recurrent' contributions as extracted from the "export CSV" button in https://opencollective.com/postmarketos/transactions?kind=ADDED_FUNDS&kind=CONTRIBUTION do not match what the API provides from collective.stats.contributionsAmountTimeSeries.nodes.amount.value

To Reproduce

  1. Extract all transactions from the postmarketOS collective like from here
  2. Read the CSV, sum all the data per month (code in https://gitlab.postmarketos.org/postmarketOS/operations/-/blob/main/financials/results.py?ref_type=heads#L56 I can reproduce with Libreoffice Calc)
  3. Verify results for August and September: recurrent 2000.37 EUR and 2123.87 EUR, respectively
  4. Go to https://opencollective.com/postmarketos
  5. Navigate down to the contributions menu
  6. Click on the bar chart and download csv (see screenshot below)
  7. Verify results for August and September: recurrent 1961.42 EUR and 2114.92 EUR, respectively. This I also get if I query collective.stats.contributionsAmountTimeSeries.nodes.amount.value with postmarketos collective with the graphql API
  8. The values are different
  9. Previous months match (I've excluded the current month as it being a moving target)

Expected behavior

The values should be the same

Screenshots

Image

Additional context
What I see that is different in these months is that some transactions seem to have come late. So some transaction for 2025-09-25 arrived somewhere around 2025-10-05

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions