Pareto Chart with Interactive Chart tool

Angelesayga

I have been trying to create a Pareto Chart with Alteryx but have not been successful. This is my data set and I want to create a bar chart with the Count field in the Y axis and the Name field in the X axis, this part works but if I try to add the Frequency field as a separate layer and Line type it is not giving me what I was expecting which is a Pareto Chart. Any ideas on how to solve this?

grossal

I am not sure what you mean with "You have Axis to Style: X: [object Object]" - can you explain this or show me a screenshot?

I am using 2020.1, that's why I might actually have options that you don't have. If you tell me your version, I might be able to test it in your version.

My process for the chart is pretty simple: 

1. Connect Interactive Chart to Input Text
2. Run it once to get the data into it
3. Interactive Chart configuration:
   1. Add Layer
      1. Type: Bar
      2. X: Name
      3. Y: Count
   2. Add Layer:
      1. Type: Line
      2. X: Name
      3. Y: Frequency
      4. Tick "Use Secondary Y-Axis"

I think you might miss the last step. Let me know if you can get it to work.

Alex