Forum Discussion
Solved
Scatter with data from two queries
Hello all, I have a simle chart to create but I don't know how. I just want to plot a x,y chart with x and y vector from one querie (sheet) et other x and y vector from another one querie. ...
Hi ODJAPO,
Please check the file here.
Solution 1: If we can change the name of the columns? Then we can append two queries as one. It will be easy after that.
Solution 2: Bring them together into one table.
1. Add an index for each table.
2. Create a new table.
Table = FILTER ( UNION ( ALL ( EGSDO2_UP_TRAN_LTR[Index], 'EGSDO2_UP_TRAN_LTR'[msabg_w], 'EGSDO2_UP_TRAN_LTR'[ResFilLtrB1_I.tiTranRaw] ), ALL ( EGSDO2_UP_TRAN_RTL[Index], EGSDO2_UP_TRAN_RTL[msabg_w], EGSDO2_UP_TRAN_RTL[ResFilRtlB1_I.tiTranRaw] ) ), ISBLANK ( [Index] ) = FALSE () )Please pay attention to your privacy.
Best Regards,
Dale
Hi ODJAPO,
Please check the file here.
Solution 1: If we can change the name of the columns? Then we can append two queries as one. It will be easy after that.
Solution 2: Bring them together into one table.
1. Add an index for each table.
2. Create a new table.
Table =
FILTER (
UNION (
ALL (
EGSDO2_UP_TRAN_LTR[Index],
'EGSDO2_UP_TRAN_LTR'[msabg_w],
'EGSDO2_UP_TRAN_LTR'[ResFilLtrB1_I.tiTranRaw]
),
ALL (
EGSDO2_UP_TRAN_RTL[Index],
EGSDO2_UP_TRAN_RTL[msabg_w],
EGSDO2_UP_TRAN_RTL[ResFilRtlB1_I.tiTranRaw]
)
),
ISBLANK ( [Index] ) = FALSE ()
)
Please pay attention to your privacy.
Best Regards,
Dale
Thank you very much for your answer.