Percent of total

[haydnr]

In addition to sum, average, min, max etc. I'd like an option in values for % of total

[yacineberdjeghl]

If you have to show it on the dashboard, you don't need to calculate a new measure because the software can automatically do the sum for you. You just need to add the new measure %= IFERROR(SUM(hours)/SUM(employees]),0)

[yacine_berdjegh]

HI guys, I was also stuck on that and I found a solution. Instead of adding a "New Column" to to show the percentage, you should add a "New measure"- then on the dashboard it will show as column1/column2 instead of an average/ median . . . 🙂

[kiyomi_olivare1]

i want to generate a % of how much hours per person did our employees get on trainging. I can calcute the quantity of employees and the total hours as a NEW MEASURE, but i want to divide this two numbers so i get the % of training by employee. those any one know how to do this?

[katarzyna_mirko]

It also would be great to have features (statistics % of row/columnl) as in matrix table for charts (bar, column, line, etc). Please, please, please 🙂

[akenn]

Definitely need % of column/row

[berniceyang]

It is a great feature! How can I change the decimals of the %, the default is 2 decimals, like 43.76%, how can I change it to 44%.

[teresa_baral]

When will percent of row/column total be added? It is a common business question that is asked about many different dimension fields. Have to create separate calculations for each one is tedious and time consuming.

[fbcideas_migusr]

Could do with percentage of column/row total being added as a display option to (non-100%) bar charts, it's something we need pretty badly and we're resorting to botching together a custom R visual in the interim period

[DamienK]

Percentage of global is great when the chart display all values, when it is a "top N" the percentage of global is in fact the percentage of the "top N" So the percentage is wrong !