Forum Discussion
nairisha
10 years agoAdvocate I
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
10 years agoAdvocate I
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
10 years agoMicrosoft Employee
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.
- nairisha10 years agoAdvocate I
Eric_Zhang In this case which column should i insert?
- Eric_Zhang10 years agoMicrosoft Employee
nairisha
My approach is as below.In "Add Custom Column", new a column named "newColumn" and formula equals ="traffic".