Forum Discussion

nairisha's avatar
nairisha
Advocate 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...
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago
nairisha wrote:

ankitpatira I don't want multiple x-axis. What I want to achieve is, suppose I have two tables 

 

 

 

 

 

 

 

 

 

 

What I would like to achieve is a X-axis of may be date and Y-axis having both value 1 and value 2 on a clustered column chart.

 

 

 

 

nairisha

For this kind of source,  you may follow below steps.

  1. In the query editor, add a custom column for each source (col="traffic",col="transaction")
  2. In the query editor, append queries to append those two tables.
  3. In the report page, use the date as X-Axis, custom column as Legend and the value as Values, then you would get something like

nairisha's avatar
nairisha
Advocate I
10 years ago

Eric_Zhang your chart resembles to the one i am looking for however, im not clear about the steps. can you ellaborate more?

 

Thanks,

Nairisha

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    10 years ago

    nairisha

     

    Did you try to follow the steps? May I know which step are you stuck by?

    • nairisha's avatar
      nairisha
      Advocate 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
        Microsoft 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.