Forum Discussion

FranciscoOjeda's avatar
FranciscoOjeda
Qrew Trainee
6 months ago

Multiple Tables Report

Hi all, I have three project tables from different business units, each with fields for contract value, contract date, and other details. We want to create a dashboard with reports combining the da...
Dashboards
FranciscoOjeda's avatar
FranciscoOjeda
Qrew Trainee

Hi Mark,

I understand this idea, and I also read about Mike's option.

I find your option more complex, and I'm not clear on the benefits compared to Mike's approach. Could you help me understand the advantages? Is the other method less scalable?

Thanks!

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 months ago

An advantage of my method is that if for some reason a pipeline fails, then in Mike's solution, the combined table may be different from the source tables.

 

Also in Mike's solution, you need a lookup field for each field you have in each of the source tables, plus a formula field to resolve which lookup to use.  So a lot of extra fields to create.