Pivot Charts and One-to-many connections

Ask the Community Get Answers
1

Hi,

I’m trying to create a management summary, and I think the best view for this is the Pivot Chart. I have tried in vain to get it working and also watched the David Parrish vid on this. I haven’t found any detail in the knowledge base.

A made-up example is probably the best way to explain what I’m trying to achieve.

  1.    A logged in ‘Senior Manager’ is looking at a (pivot) table where the rows are Projects, the A column being their project name.

  2.    Column 2 is a count of all the team members who have so far worked on each project (one-to-many with tProject and tTeamMembers).

  3.    Column 3 is a count of all days the project has taken so far. (one-to-many between tTeamMembers and tTeamMembersDailyTmeSheet).

Result: **Alan Parsons Project | 4 | 345
**
The chatbot says it is possible for such a report but I am now wondering when it says “You can absolutely use connected tables”, what it actually means is, connected tables but only one above (parent) and one below (child) and nothing else.

My actual report uses 4 tables.

Q. Can I create a summary report whereby I can report on connected tables i.e. Parent>Children>GrandChildren>GreatGrandChildren.

I am new to Knack so if anyone can point me in the right direction or videos or docs, I would be very grateful.

Many thanks,

Dom

2

I have this problem also. I have an orders table and a payments table and need information from both and thus far I have created two different summaries on the same page and the user needs to make sure to change the dates filter on both. :unamused_face: