Using a variation of the 'job posting' template provided by Knack.
I'd like to create a pivot report showing count of (table.applications) by table.job.name.
That is, I want to show "how many applications do I have for each job".
I can't seem to do this. I can't create a join on two tables and then create a report on this join? Or I can't create a view and pivot on this view. I also can't add job.name to the application record when a new application record is created (not good database practice) so that I could then pivot applications by name.
It seems so close in the Table view of Jobs when I add a column of the related applications records. I can almost see the 'sum' function ... but it's not there.