Forum Discussion
Solved
Charting data from two tables with conditions
Hello, I've submitted this question already but it never appeared so I have to submit it again. I'm stumped again. I've spent the last couple hours reading the forums and nothing helped. What...
Whoop! I just finally figured it out on my own. After I realized that it doesn't work if I use the customer from either table, I finally had the realization that maybe I need to use the customer that is joining the two tables, and that solved my problem! Can't believe I didn't think of that hours ago.
So if I move use the "Customer" from the Stops table instead of the Orders table, the Scanning is right but the Revenue is wrong. It gets the right data from whatever table the Customer is on, but the other isn't. How do I get both to be right? Somehow I need this graph to match the customers from the two tables, but they can't be joined.