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

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.

 

 

 

 

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft 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