Good afternoon,
Is it possible that the percentage...
# gooddata-uin
Nuno Salgado
03/27/2023, 1:33 PMGood afternoon,
Is it possible that the percentage calculations in the tables are not 100% for all elements in the rows and columns, but be something where we can define whether we want 100% for the row or 100% for the column?
Nuno Salgado
03/27/2023, 1:34 PMScreenshot 2023-03-27 at 14.26.46.png,Screenshot 2023-03-27 at 14.32.26.png
Nuno Salgado
03/27/2023, 1:34 PMWe what 100% in the sum of % column A, B and C
Nuno Salgado
03/27/2023, 1:35 PMor the row for example
Nuno Salgado
03/27/2023, 1:35 PMnot in all the table
c
Carol Hood
03/27/2023, 1:35 PMI'm not using %
n
Nuno Salgado
03/27/2023, 1:36 PMSorry @Carol Hood im not a gooddata staff 🙂 this is a question from a gooddata user as well 🙂
👍 1
m
Moises Morales
03/27/2023, 3:10 PMHi Nuno, I am afraid that this is not possible as the percentage is applied globally. You could create a metric with the WHERE clause that would allow you to filter the values to which the percentage would be applied, but I’m afraid it’s not close to what you want. May we know your use case?
n
Nuno Salgado
03/27/2023, 4:50 PMThanks for the response @Moises Morales but yeh Where will not resolve the problem. The example is what I showed previously use % not for global measurement by % in a row or a column, something that can be done is use a stacked barchart, but we would like to do in tables.
Nuno Salgado
03/28/2023, 8:30 AMIs this something that is on roadmap? As you can see in tableau this is not something new. They already suporte this. This helps a lot in some analysis. You can check here;: https://help.tableau.com/current/pro/desktop/en-us/calculations_percentages_options.htm
Nuno Salgado
03/28/2023, 8:31 AMScreenshot 2023-03-28 at 09.31.07.png
p
Productboard
03/28/2023, 12:36 PM🎉 New note created.
m
Moises Morales
03/28/2023, 4:18 PMThank you for the details. I have submitted this as a feature request for potential future product improvements
🙌 1