Chart missing data influencing other charts

[Thijxx]

Bug Report

Expected Behavior

Show multiple charts.

Actual Behavior

If I have a chart with no data for a couple of days, other charts will also drop data for those days.

Steps to Reproduce the Problem

1. Create a chart for a period with some missing data
2. Create another chart for some other SQL filtered selection
3. Notice the disappeared data

The right chart has all data, the left chart misses a couple of days.

Specifications

• Version: 1.0.7
• Platform: Centos 8
• Grafana Version: 6.2.2-2

[Thijxx]

SQL within grafana

#standardSQL
SELECT
 $__timeGroupAlias(timestamp,10m,1h),
  avg(`sensorvalue`) /100 AS sensorvalue
FROM `hypercloud-252112.hyperwarehouse.staging_tickle2019`
WHERE
  $__timeFilter(timestamp) AND
  nodeid = 749 AND
  sensorid = 1
GROUP BY 1 
ORDER BY 1 DESC

SQL as logged by BigQuery

#standardSQL
SELECT
 TIMESTAMP(  (PARSE_DATE( "%Y-%m-%d",CONCAT( CAST((EXTRACT(YEAR FROM `timestamp`)) AS STRING),'-',CAST((EXTRACT(MONTH FROM `timestamp`)) AS STRING),'-','01')))) AS time,
  avg(`sensorvalue`) /100 AS sensorvalue
FROM `hypercloud-252112.hyperwarehouse.staging_tickle2019`
WHERE
  `timestamp` BETWEEN TIMESTAMP_MILLIS (1587999590573) AND TIMESTAMP_MILLIS (1588604390573) AND
  nodeid = 749 AND
  sensorid = 1
GROUP BY 1 
ORDER BY 1 DESC LIMIT 1280

[Thijxx]

Fix: $__timeGroupAlias(timestamp,1h),

Maybe, the GUI query builder resulted in an odd parameter for $__timeGroupAlias?

[LiorRacer]

Hi @Thijxx,
Can you reproduce it on public dataset?
I tried it with my own data and it didn't reproduce:

[Tamirk]

@Thijxx closing this for now but if you have any information on this feel free to let us know