Forum Discussion
Pi chart across 2 tables
I knew there had to be a simple soultion!!
I just had to add a data source with my original SQL Query, then I simply used the same formular to run my report off the correct field.
Yes. I was creating a new field that had a Found/NotFound value, and I am just after a percent complete.
Like this:
This image is off a defferent field that I did as a test, it worked because there was a line item regardless of wether there was a value or not. Unfortunatly when it use the field that i actually need (not my test one) it is in another table that only contains a line item when there is a value.
Basicly, old one was like this
WorkstationID, Comp, 123
WorkstationID, Comp2, 456
WorkstationID, Comp3, Null
WorkstationID, Comp4, 789
New one is like this. (No WorkstationID for the Null value)
WorkstationID, 123
WorkstationID, 456
WorkstationID, 789
So I need to use the relationship to look at every Workstation ID, and if it doesn't have a match in other table report it as null..
Otherwise i get this
I fell like its something simple, i just can't crack it for some reason..
After reading this site i thought it was going to be as simple as this
Test = EVALUATE NATURALLEFTOUTERJOIN ( SystemInfo, Workstation_Fields )
But it doesn't recognise this command