In my application, as a part of creating a ‘a new project’, I allow end-users to select certain sites from a shuttle and store those in another table. In this way, one project can encompass one or more sites. What I am struggling to do is plot certain data for those sites in another page that contains the project info. For example, if for project 1 the end-user selects sites A, B and C I would like to have either a tabular or graphical visualization for key data for each site. So for each site perhaps I would have a table that contains a summary of basic stats for that site or perhaps a plot that depicts cumulative use of that site over the years.
My main question is, how can I use APEX to create a variable number of graphs or interactive grids/reports based on data that is present in a table? If a project as one associated site, I would expect one site/table, if two then two, etc.
Thank you