Forum Discussion

ODJAPO's avatar
ODJAPO
Frequent Visitor
8 years ago
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.  ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi ODJAPO,

 

You can upload the sample to a cloud drive like OneDrive, GoogleDrive and paste the shared link here if you can make it public. Or send me a private Message.

 

Best Regards,

Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    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

    • ODJAPO's avatar
      ODJAPO
      Frequent Visitor
      8 years ago

      Thank you very much for your answer.