I have multiple bases that need to remain separate and one primary base where I need to track the average of a ranking between the other bases. Is there a way to reference a specific value in each of these other bases and display the average? I’ve only been seeing posts and videos about how to calculate an average from different tables within the same base. Also is there a way to make this a weighted average?
Will I need to sync/copy these separate bases into the primary base to then calculate the average of the field?
Thanks in advance!