Hi team, I've got a quick question about an issue...
# gooddata-cloud
e
Hi team, I've got a quick question about an issue we're having with column aggregations in tables. For percentage columns, there's no aggregation that gives the overall ratio. To give an example, let's say there's a percentage metric called Ratio A, and let's say we use it at the item level to see each item's Ratio A value. We wanted to have a column aggregation that shows the overall Ratio A of all data. So let's say if the items are: 1. param1 = 1, param2 = 10: Ratio A of this item = 1/10 2. param1 = 2, param2 = 5: Ratio A of this item = 2/5 I'd like the column aggregation to show (1+2) / (10+5), but none of these aggregations worked for us. The closest was AVG, but it does (1/10 + 2/5) / 2, which is not correct. Any ideas if there's a column aggregation that gives the overall ratio calculation for percentage columns? Let me know if the issue is not clear or if you have any questions. Best
k
New message text here