Skip to main content

Hi.

 

Question: How can i do a relationshio in Tableau.

I want to relationship the filter Created MM/YY with the table name RFS From Dec 2017 (2).

 

Thanks for all.

 

relationship

3 answers
  1. Aug 16, 2018, 9:42 PM

    Hi Claudia,

     

    You need to update the relationship between your data sources.

    First, I can see that in your JOIN dataset you have the Created MMYY field. You'll need to make the same field in the same format in your data source sc_req_item (as your RFS from Dec 2017 uses this data source). Right click on the data field from sc_req_item  and create a month/year custom date field.

     

    Now, in a worksheet, edit the relationship between the data sources Join and sc_req_item :

     

    Hi Claudia, You need to update the relationship between your data sources.First, I can see that in your JOIN dataset you have the Created MMYY field.

     

    Add in a new relationship:

     

    2018-08-16_22h41_30.png

     

    Select the two MM YY fields and click ok.

     

    2018-08-16_22h38_55.png

    Now go back to your dashboard, and you should be able to check on the worksheet

    2018-08-16_22h39_16.png

     

    Thanks,

     

    Mavis

0/9000