So in other words I would like to create a list in a row the title of the activities and the points, an organisation gives to make a Pie chart after all.
Can someone point to the direction which formulas I should use?
This is the probably what got you here asking this question. Without seeing the data, I have a hunch that the data table could be better designed to be “viz-ready”. Ideally, you shouldn’t need to make copies of your data to visualize your data. But this requires some planning.
My first question - why aren’t these rows instead of columns? And further - are activities occurring over time? i.e., rows for org/activities by date?
If you are unable to imagine a data model that supports all requirements - i.e., there’s a conflict between the best model and the most appropriate shape of your data for your business, you can build viz-ready tables as a function of other data. I do this from time to time by using webhooks that send records to another table which allows me to parse the data and store it in a format that us suitable for the visualization you want to display.
