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 tabs: Course1 and Course2. And I want to create a graph that can Join the two course and the create a slicer from which i can select only one option to see the KPIs.

 

Thanks!

Need Help

2 Replies

  • 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!!