Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Problem 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 a...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Hariharan_R's avatar
Hariharan_R
Icon for Solution Sage rankSolution Sage
4 years ago

Hi,

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

 

Thanks

Hari

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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