percentage of how many people filled the mandatory field calculation on the Alteryx

[Nuran_34]

Hello , I would like to get information how to create data of the excel. For Example I have the all record of the registration in the application . I wanna analyze how many percentage of people filled the each part. For more clearance. for each mandatory field and not mandatory field . I would like to calculate how many people filled it how many people did not / skipped it . I would like to show it on the Excell .

Waiting for your help :) 

[KGT]

This would be better posted in Designer Desktop as it's not a Machine Learning use case and there will be a lot less people watching this discussion board.

You need to set up your data and show what it looks like (and a sample of the data ideally).

You just need

• A list of the registrations
• Summarise that to get the total per part
• Summarise in PARALLEL for whatever other totals you need
• Join or append these totals on
• Formula to work out the percentage.