Forum Discussion
AdministratorProblem extracting percentages for a card
Good afternoon
I need to make a card that shows me the percentages that are repeated with respect to the total, to be able to show in this case the percentage of events that have happened in an area.
Normally I put it and I always get a hundred and I am not able to find a solution, trying many calculations
Let's see if someone can help me
Thanks a lot
HI Sdatasoccer55,
It sounds like you want to use a formula to calculate with multiple aggregations. If that is the case, you can take a look at the following blog which mentions measures calculated with multiple aggregations:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
4 Replies
- Hariharan_R
Solution Sage
Hi,
Can you share your sample data? In general, you need to write like below.
Thanks
Hari
Syndicate_AdminGood afternoon
The column 'NOM' has up to 10 variables strings, I want to use that percentage for when I give a value of those columnS I get the total percentage that has happened in that variable of 'NOM'. That is to say, I want to know the total percentage of accidents in that district, differentiated by each of them.
Thanks a lot
Sorry for the inconvenience
HI Sdatasoccer55,
It sounds like you want to use a formula to calculate with multiple aggregations. If that is the case, you can take a look at the following blog which mentions measures calculated with multiple aggregations:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
- Syndicate_Admin
Good afternoon
The column 'NOM' has up to 10 variables strings, I want to use that percentage for when I give a value of those columnS I get the total percentage that has happened in that variable of 'NOM'. That is to say, I want to know the total percentage of accidents in that district, differentiated by each of them.
Thanks a lot
Sorry for the inconvenience
