Forum Discussion
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...
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.
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.
- 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.
