We currently have a custom rule that allows users to create a new average column(s) based on an average for each row per span per category: https://www.notion.so/displayr/Average-for-each-row-per-span-category-11b9a1646eb1803ba971c7b0cd818b27?source=copy_link

See the attached image for an example of the desired calculation.

Suggesting that this be added to the rules readily available to users.