Problem extracting percentages for a card

[Syndicate_Admin]

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

[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

[Hariharan_R]

Hi,

Can you share your sample data? In general, you need to write like below.

Thanks

Hari

[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

[Anonymous · Accepted solution]

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