title: Multi series line graph in GRAFANA
body: <p>I am trying to develop a multi series line graph in grafana with mysql queries.</p>
  
  <p>Here I had two mysql query , but the graphs appear in continuous manner and not in multi series line manner.</p>
  
  <p>Below I pasted the graph.
  <a href="https://i.stack.imgur.com/GBNoT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GBNoT.png" alt="enter image description here"></a></p>
  
  <p>Here the x-axis (months) are repeating and the graph is not overlapping. Kindly suggest for this. </p>
  
  <p>Below I pasted the two queries</p>
  
  <p>Query A:
  SELECT
    UNIX_TIMESTAMP(creation_Date) as time_sec,
    count(status) as value,
    month as metric
  FROM <code>'january'</code>
  where Source='Doors'
  group by status
  UNION
  SELECT
    UNIX_TIMESTAMP(creation_Date) as time_sec,
    count(status) as value,
    month as metric
  FROM <code>'feburary'</code>
  where Source='Doors'
  group by status
  UNION
  SELECT
    UNIX_TIMESTAMP(creation_Date) as time_sec,
    count(status) as value,
    month as metric
  FROM <code>'march'</code>
  where Source='Doors'
  group by status
  UNION
  SELECT
    UNIX_TIMESTAMP(creation_Date) as time_sec,
    count(status) as value,
    month as metric
  FROM <code>'april'</code>
  where Source='Doors'
  group by status
  UNION
  SELECT
    UNIX_TIMESTAMP(creation_Date) as time_sec,
    count(status) as value,
    month as metric
  FROM <code>'may'</code>
  where Source='Doors'
  group by status;</p>
  
  <p>QueryB:
  SELECT
    UNIX_TIMESTAMP(creation_Date) as time_sec,
    count(status) as value,
    month as metric
  FROM <code>'january'</code>
  where Source='RTC'
  group by status
  UNION
  SELECT
    UNIX_TIMESTAMP(creation_Date) as time_sec,
    count(status) as value,
    month as metric
  FROM <code>'feburary'</code>
  where Source='RTC'
  group by status
  UNION
  SELECT
    UNIX_TIMESTAMP(creation_Date) as time_sec,
    count(status) as value,
    month as metric
  FROM <code>'march'</code>
  where Source='RTC'
  group by status
  UNION
  SELECT
    UNIX_TIMESTAMP(creation_Date) as time_sec,
    count(status) as value,
    month as metric
  FROM <code>'april'</code>
  where Source='RTC'
  group by status
  UNION
  SELECT
    UNIX_TIMESTAMP(creation_Date) as time_sec,
    count(status) as value,
    month as metric
  FROM <code>'may'</code>
  where Source='RTC'
  group by status;</p>