# Join transform for time series

**URL:** <https://community.grafana.com/t/join-transform-for-time-series/103267>\
**Category:** Time Series Panel\
**Created:** [September 11, 2023, 12:01am UTC](https://community.grafana.com/t/join-transform-for-time-series/103267 "2023-09-11T00:01:09Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![runamook](https://avatars.discourse-cdn.com/v4/letter/r/977dab/32.png) [@runamook](https://community.grafana.com/u/runamook)\
**Post date:** [September 11, 2023, 12:01am UTC](https://community.grafana.com/t/join-transform-for-time-series/103267/1 "2023-09-11T00:01:09Z")

</div>

- What Grafana version and what operating system are you using?  
OS Grafana 10.1.0, 10.1.1

- **What** are you trying to achieve?

Mixed data source.

1. MS SQL query returns time-series data “time”, “metric-id”, “value”
2. PG SQL query returns table data “metric-id”, “metric”

Aim - visualize time series as  
MS-SQL.“time”  
PG-SQL.“metric” (multiple keys)  
MS-SQL.“value”

- **How** are you trying to achieve it?

Using mixed data source I’m making two queries (MSSQL + PGSQL) that return data as above.

1. Applying transform “Join by field”.INNER by “metric-id”
2. Applying transform “Filter by name”.metric-id

These transforms leaves me with a three desired columns, namely MS-SQL.“time”, PG-SQL.“metric”, MS-SQL.“value”.  
But to my greatest sorrow it only works is MS-SQL query Format is set to Table.  
If it is a Table format - time-series visualization doesn’t work.  
If it is a Time series format - transformation doesn’t work correctly.

Referring to transformed data from another panel as a “Dashboard” data source has no effect.

Am I doing anything wrong?