Forum Discussion

rashel2002's avatar
rashel2002
Helper II
8 years ago
Solved

Line Chart- Multiple Lines Each Based on different table i created

Hi Everyone!

 

I would like to create one Line Chart which based on two different tables (each of them was created from a different query).

there is a way to extract data from two different tables? until now i succeeded to extrct data from one table only, and now i want to merge those two line-chart i got, into one line-chart.

 example-

Currently i have those tables-

 

PLEASE PAY ATTENTION- i'm looking for a different solution then editing those queries (which are the source of each table i created) into one query!

all i want is create one line from one table, and another line from the second table.

 

Thanks!!

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    I believe what you want is a third table with just your DISTINCT WW's in it. You then would relate that table to your other two tables and use the WW column from this third table as your axis in your line chart.

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    I believe what you want is a third table with just your DISTINCT WW's in it. You then would relate that table to your other two tables and use the WW column from this third table as your axis in your line chart.

    • rashel2002's avatar
      rashel2002
      Helper II
      8 years ago
      How do i creat the third table? I need to extract the WW column from one of the queries (as i said i have 2 queries and i created a tables from each of them[two table in total as in the example]). If i choose one of the queries, then when i'll try to put the data from the table made from the other query, it will show a straight line.