Skip to content
This repository has been archived by the owner on Dec 11, 2022. It is now read-only.

__timeGroup does not use my time variable #242

Closed
marcbichon opened this issue May 14, 2020 · 2 comments
Closed

__timeGroup does not use my time variable #242

marcbichon opened this issue May 14, 2020 · 2 comments

Comments

@marcbichon
Copy link

Bug Report

Expected Behavior

I try to build a timeline with the following query:

SELECT
  $__timeGroup(input.timestamp, 1h),
  COUNTIF(metric)
FROM table
GROUP BY time

Actual Behavior

  • The panel displays "no data" instead of the expected timeline
    image
  • There is no error (no red icon in the top left corner)
  • In my browser console the query which run is the following:
SELECT
  TIMESTAMP_SECONDS(DIV(UNIX_SECONDS(`-- time --`), 3600) * 3600) AS time,
  COUNTIF(metric)
FROM table
GROUP BY time LIMIT 1856
  • The surprise is this --time-- parameter instead of my input.timestamp parameter

Specifications

  • Version: 1.0.7
  • Grafana Version: 6.7.1
@LiorRacer
Copy link
Contributor

Hi @marcbichon,
I believe that you used the query builder, right?
If so can you verify that you select Time Column, for example:
image

@Tamirk
Copy link

Tamirk commented Jun 3, 2020

@marcbichon if @LiorRacer answer is not solving your issue please open with more details

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants