Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Conect two sheets to one report.

Hello!   I've a report which is imported from Google Sheet and I want to do a graph which can join the data from the diferents fields (which are the same in all tabs).   For example: I've two ta...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

I may be missing something here, but it sounds like you either need to create a relationship between your two tables or append them together. I am assuming that you have a separate query to import each tab of your Google Sheet?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello! Thanks for the response. 

 

Yes, I don't know if I should create a relationship, append fields or create a calculated columm. Because, in the near future,I'm going to add new course so I've to plan a model that can resist this changes without break the report.

 

This is an example:

 

I want fields in MKT01TN y MKT02TM feed one graph and then I can choose whit an slicer the propper course.

 

I hope I have explained clearly my doubt

 

Thanks!!