Link Dates from two tables

---

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