Paginated Report - Line chart not plotting correctly when I use LookupSet().

[Abishek]

Hi,

I'm using LookupSet in a Paginated report.
This works well in a table when I use the Join() function with LookupSet().
However, when I try to plot a line chart, the visual is not displaying correctly. Can someone please help?

Category Group: Join(LookupSet(Fields!ID.Value, Fields!ID.Value, Fields!Date.Value, "Scores"),",")
Value: Join(LookupSet(Fields!ID.Value, Fields!ID.Value, Fields!SCORE.Value, "Scores"),",")

Thank you.

[divyed]

Hello @Abishek ,

Please provide more details along with sample data (without sensitive). 

Using LookupSet with JOIN is great for a table, but a line chart expects separate values rather than a single, comma-separated string. Here are a few steps you can try to display your data properly in the line chart:

1. Separate Aggregation Logic: Create a dataset that fetches the individual values directly rather than aggregating them with LookupSet. This will let you use the fields as separate data points on the chart without joining them into strings.

2. Chart Data Properties: Set the Categoty Group and Value fields directly from the dataset you created (or the one that holds the date and score values). This way, each ID or date has its own data point on the line chart.

I hope this helps. 

Cheers

[Abishek]

Hi @divyed ,
Thanks for replying,

1.this is the main table:

ID	Name	Subject
1	Student A	Math
1	Student A	Science
1	Student A	English
2	Student B	Math
2	Student B	Science
2	Student B	English

2.the Scores Table

ID	Date	Score
1	2024-01-01	95
1	2024-01-02	90
1	2024-01-03	88
2	2024-01-01	87
2	2024-01-02	95
2	2024-01-03	98

For example: This is the table. I'm developing a report for a student-wise report, with one student per page. I want to plot the score table data as a line chart using LookupSet().

Note: I have one main table, and the page break is between each instance of the group. This line chart comes inside the table

Thank You !