Issue with summarizing data selected from a list box

[syinti]

I am sure my understanding of the dynamic tools is probably off here, hence reaching for help. 

Attaching a pic of what my analytic app looks like.

Input macro that gets a list of data from one table.

User is asked to select which columns he wants "Counts of"

And when the app is run, it should give counts of that selected field.

Example: Table has 20 rows with name, birthdate, gender, cityname.

If I select gender, it should give me an output of - 10 male and 10 female.

What step am I missing? How do I tell the summarize tool to pick the selected field?

[PhilippK]

Hi @syinti ,

please find a mock solution attached:

 

Does this help you?

If not, it would be good if you send me your current workflow or at least show me how the data looks like before it flows into your summarize tool.

Best regards

Phil

[syinti]

@PhilippK  - the one you have is what the basic summarize tool is and you are selecting which fields to summarize.

My question is more of how to do it dynamically. As in, how do you do it as an analytic app where user selects the fields?

Let me see if i can modify my wf to attach it here without identifying info.

[PhilippK · Accepted solution]

Hi @syinti ,

I extended the workflow to a full analytical application and include the dynamic part.

Is this the solution you were looking for?

Best regards

Phil

[syinti]

@PhilippK - Thank you. It is the transpose that I didn't do. With the transpose it now works like you gave here. 

[PhilippK]

perfect! 🙂