Forum Discussion

nairisha's avatar
nairisha
Icon for Advocate I rankAdvocate I
10 years ago

Link Dates from two tables

Hi,   I have two tables in my database, one containing the traffic details in a shop and another containing the transaction. Each table records the datetime when someone entered the shop and purcha...
nairisha's avatar
nairisha
Icon for Advocate I rankAdvocate I
10 years ago

Eric_Zhang i did but while creating the custom column, i did not understand which column to insert and why i need to do it.

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

nairisha

 

Add custom column valuing "tracffic "to traffic table and "transaction" to transaction. In latter steps those two table would merge into one and the newly added column is used as a legend in the visual.

  • nairisha's avatar
    nairisha
    Icon for Advocate I rankAdvocate I
    10 years ago

    Eric_Zhang In this case which column should i insert?

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    nairisha

    My approach is as below.

     

    In "Add Custom Column", new a column named "newColumn" and formula equals ="traffic".