Display the result of dividing TimeSeries-value by plain-SQL-query value within a single dashboard: No data

[fedorv]

• What Grafana version and what operating system are you using?*
  Grafana Playground
  Grafana v11.1.0-69950

• What are you trying to achieve?
  I need to display the result of dividing TimeSeries-value from Datasource 1 by plain-SQL-query value from Datasource 2 within a single dashboard

• How are you trying to achieve it?

• I retrieve data from 2 different Datasources within a single dashboard (I use --Mixed-- datasource); first datasource sends data in TimeSeries format (result 1), second datasource - as a plain SQL query response (result 2).

• I create “Expression” Element in Query tab:
  Type: Expression
  operation: Math
  Expression: $DataSourceA / $DataSourceB

• What happened?
  “No data” text is displayed in a new column; Warn-Icon with Status 500, Status text: “Internal server error”, url: “api/ds/query?expression=true”

• What did you expect to happen?
  A new column with the result of dividing TimeSeries-value from Datasource 1 by plain-SQL-query value from Datasource 2

• Did you receive any errors in the Grafana UI or in related logs?
  Warn-Icon with Status 500 in a new column, Status text: “Internal server error”, url: “api/ds/query?expression=true”

[sowdenraymond]

try a transformation:

[fedorv]

Hello @sowdenraymond ,
thank you for advice!

I think I’ve found a solution (see printscreens: ID is a row SQL query result, Reduced Backend Requests is a time-series data)