Data source columns not sorted correctly

[Logan]

Good Morning,

I am trying to generate a simple report using a CSV data source. The data source contains applicant information including their university, name, state, etc. The CSV also contains information on the stage of the application, whether it was a whitepaper or full proposal etc. When trying to generate a simple bar chart of the count of the different stages, (i.e.,  count of how many whitepapers) the field stage also contains the states on the y axis in the chart. It seems the field stage and state are being intertwined when this is not what I want. Is there any solution to this? These fields are clearly separated in the CSV and the data preview when importing the CSV.

 

Thanks

[Logan]

The error is coming when the CSV is parsed

[Neli]

Hi Logan,

I tested the described approach, however, I am afraid that I was not able to reproduce the problem. Please, consider sending me your report with sample data, so I can inspect it locally.

[Logan]

Thanks Neil. I actually fixed this issue. Several cells in the csv had commas in the text, which shifted the data over into the states column. I had to clean the CSV further and issue was solved.