topic Row total, not percent not total in SAS Visual Analytics

Row total, not percent not total

ghartge — Sun, 28 Jun 2020 19:17:05 GMT

Hey everyone,

I am at a loss here and need help. This seems like it should be something very easy to, and it probably is, but I am completely missing it.

I simply need to add a calculation that takes the "Failed" value and divides it by the "Passed" value in the attached document for each semester (fall and spring) down the column. In other words each row should have a percent for each year and semester.

I have a field in the attached document titled "Calculated Item 2" which is where this calculated value should go and appear to the end user. I have several years across the top with semesters under those.

Thanks everyone, very frustrated here.

Gary

Re: Row total, not percent not total

PetriRoine — Mon, 29 Jun 2020 07:14:33 GMT

Hello @ghartge ,

You need to use Aggregated Measure. Please try this:

Sum [_ByGroup_] ('Failed'n) / Sum [_ByGroup_] ('Passed'n)

Below is a picture showing the difference between using simple calculated measure Failed / Passed and aggregated measure Sum ByGroup Failed / Sum ByGroup Passed.

I hope this helps!

Best regards,

Petri

Re: Row total, not percent not total

ghartge — Mon, 29 Jun 2020 12:44:07 GMT

Thank you PetriRoine!

I swear I tried that and it produced very odd values, but I obviously did something incorrectly. Thank you for the clarity.

Regards,

Gary