We’re trying to create a Leaderbord chart to show what content is mot popular within our app.
To calculate this we need to join some data together.
Basically we have:
Course --hasMany--> CourseVersion --hasMany--> CourseCompletion
What we want to do is to count the
CourseCompletion objects grouped by Course and show them in a leaderboard with column headers:
“Course name | Course completion count”.
From what I gather the only possible relationships that we can use in the chart builder is the ones defined as “hasMany” in the “models/model-name.js”-file.
On top of that, I cannot find any way of using join tables for the relationships there, instead we’ve used routes to get it working.
So my question is, is there some way of creating this kind of a join query in the chart builder?