Averages are very skewed in some categories

[teolemon]

Hypothesis:

• the kcal/kj conversion
• the lack of kcal values skewing averages ? https://world.openfoodfacts.org/product/5400119531986/trempette-a-la-tomate-delhaize

[hangy]

https://drive.google.com/file/d/1bVPe1NNwjKOte8L2q-ZL55uNURjZ3sX7/view?usp=sharing

Since only the field energy_100g exists for all products, maybe the individual energy-kj_100g and energy-kcal_100g fields should be ignored for averages? While the calculation might not be 100% accurate, that sounds more reasonable than comparing averages of products that don't contain explicit values for some of those fields.

[stephanegigandet]

Agreed, we could just not show comparisons for energy-kcal and energy-kj.

[github-actions[bot]]

This issue has been open 90 days with no activity. Can you give it a little love by linking it to a parent issue, adding relevant labels and projets, creating a mockup if applicable, adding code pointers from https://github.com/openfoodfacts/openfoodfacts-server/blob/main/.github/labeler.yml, giving it a priority, editing the original issue to have a more comprehensive description… Thank you very much for your contribution to 🍊 Open Food Facts