Data source columns not sorted correctly

0 Answers 21 Views
DataSource CSV Filtering Graph Grouping Report Designer (standalone) Sorting
Logan
Top achievements
Rank 1
Logan asked on 24 Jan 2022, 04:52 PM

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
Top achievements
Rank 1
commented on 25 Jan 2022, 08:53 PM

The error is coming when the CSV is parsed
Neli
Telerik team
commented on 27 Jan 2022, 03:10 PM

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
Top achievements
Rank 1
commented on 27 Jan 2022, 05:51 PM

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.

No answers yet. Maybe you can help?

Tags
DataSource CSV Filtering Graph Grouping Report Designer (standalone) Sorting
Asked by
Logan
Top achievements
Rank 1
Share this question
or