Calculating percentage in alteryx

Hello everyone,

I've been trying to calculate the % of attendance to an event by society. Ideally I would like to have a column in alteryx that showcases the % of attendance to an event (taking into account the total number of students in the society and the total number of events attended).

Ideal output

Thank you

Datasets

Data Investigation

Events

Accepted answers

atcodedog05

Hi @suds144

Just adding to @binu_acs approach which meets the requirement. Note that when you display with % sign it will turn to string. You show it without percentage so that it is treated as number.

Hope this helps : )

Attendence.yxmd

atcodedog05

Hi @suds144

Use a select tool and convert datatype to double.

Workflow:

Hope this helps : )

Attendence (1).yxmd

All comments

Hi @suds144

Just adding to @binu_acs approach which meets the requirement. Note that when you display with % sign it will turn to string. You show it without percentage so that it is treated as number.

Hope this helps : )

Attendence.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703