Hi guys,
I just started using Apex last week so I hope someone can help me answering this question. Ultimately, I want to create chart(s) from a report page - it can be zero or many charts depending on how many rows shown in my report page. So here is a simplified example of my case, to give you context:
I have a table of Student, each record shows a student's name, a class taken, and a progress:
| ID | Name | Class | Progress |
|---|
| 1 | Danny | Python Programming | COMPLETED |
| 2 | Danny | Java Programming | IN PROGRESS |
| 3 | John | Software Design | IN PROGRESS |
| 4 | Alex | Database Introduction | COMPLETED |
Then, I made a Report page using a SQL query, processing the data from the Student table into this:
| ID | Name | Completed Class | Incomplete Class |
|---|
| 1 | Danny | 1 | 1 |
| 2 | John | 0 | 1 |
| 3 | Alex | 1 | 0 |
Now, I would like to generate chart(s) on the same report page, below the report. One chart for each student. There can be 0 or many charts depending on how many unique students recorded in the Student table. How to generate all the charts automatically? I cannot possibly add chart region one by one in the page designer since I do not know how many students will come. Any help will be appreciated!
I am using Apex v 5.0.3, theme Vita.