Issue when stacking time series with mixed datasource (Grafana version 9.1)

[lpinochi]

• What Grafana version and what operating system are you using?
  Grafana version 9.1 OS: Redhat linux 8.4

• What are you trying to achieve?
  Correctly stack time series from different datasources.

• How are you trying to achieve it?
  I have 2 queries. One is a openTSDB query, and the other one is a PNP.
  In time series options, I use the stack option in Normal.

• What happened?
  Opentsdb has a donwsample of 5 minutes. PNP has a downsample of 5 minutes too, but the time series shows values per minute, repeating values, since it only changes every five 5 minutes.
  

  
  
  

• What did you expect to happen?
  I have this same query in Grafana 6.7, both datasources are the same and time series are stacked together correctly.
  

  

• Can you copy/paste the configuration(s) that you are having problems with?
  If you need any settings, please let me know.

• Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
  No errors shown.

• Did you follow any online instructions? If so, what is the URL?
  I found no instructions for issues like this.

[sowdenraymond]

can you show a table view of your data?

[lpinochi]

Hi, sorry for the delay, Here a attach in table format.
For queries taken from the openTSDB, I have values every 5 min:

And for PNP, as i said before, it shows values per minute:

Please let me know if you need anything else. Thanks.

[sowdenraymond]

can you try add a concatenate transform?

before:

after:

[lpinochi]

Thanks, it looks like the graph is fine now. The only issue is that i am getting the “data outside time range” message. I am trying to figure it out

Let me know if you found a similar message like this before. Regards.