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

Only a single value is plotted #193

Closed
nielsbasjes opened this issue Feb 3, 2020 · 8 comments
Closed

Only a single value is plotted #193

nielsbasjes opened this issue Feb 3, 2020 · 8 comments
Assignees
Labels
bug Something isn't working
Milestone

Comments

@nielsbasjes
Copy link

Bug Report

When selecting multiple values in a query only the first one is shown in the line graph.

Expected Behavior

I would like to see a line for each retrieved value.

Actual Behavior

Only the first one is plotted.

Steps to Reproduce the Problem

I have a test project with a table with several numerical columns.
I also have columns created with the HyperLogLogPlus functions Google has provided.
Although these are BYTES columns they can be aggregated and a number can be extracted.
In the example below the countDistinctSessionIdSketch column is such a column.

When running this query I ONLY get the first column. In this example it is the output of the HLL_Count.merge. If I change the query to be a basic selection of several numerical values the effect is the same. If I build a simple multi value query using the query builder the effect is the same.

    #standardSQL 
    SELECT 
        TIMESTAMP_SECONDS(DIV(UNIX_SECONDS(`windowTimestamp`), 60) * 60) AS groupTimeStamp,
        HLL_Count.Merge(countDistinctSessionIdSketch)        AS distinctSessionId,
        SUM(measurements)                                    AS measurements
    FROM `myproject.mydataset.mytable` 
    WHERE `windowTimestamp` BETWEEN TIMESTAMP_MILLIS($__from) AND TIMESTAMP_MILLIS($__to)
    GROUP BY groupTimeStamp
    ORDER BY groupTimeStamp 

Specifications

  • Version: 1.0.5
  • Platform: Linux
  • Grafana Version: Version 6.6.0 (5c11bbdfb4)
@avivl
Copy link
Contributor

avivl commented Feb 4, 2020

@nielsbasjes I'm not a Grafana expert, however, I think that the way to display multiple values in Grafana is to create multiple queries

@nielsbasjes
Copy link
Author

I have Grafana attached to the data from my electricity meter and I can simply select multiple values from the database (in this case InfluxDB) and see them in a single graph in one query (see screenshot).
Also when I look at the data coming back from BigQuery into Grafana using the query inspector I actually see the values I requested coming back into grafana. So the query I specified is being executed correctly, it somehow only shows the first value as a line instead of all the returned values.

image

@MassyB
Copy link

MassyB commented Feb 10, 2020

@nielsbasjes thanks for opening this issue. I have the same one.

@avivl avivl self-assigned this Feb 10, 2020
@avivl avivl added the bug Something isn't working label Feb 10, 2020
@avivl avivl added this to the 1.0.6 milestone Feb 10, 2020
@avivl avivl closed this as completed in e4586f5 Feb 10, 2020
avivl added a commit that referenced this issue Feb 10, 2020
@nielsbasjes
Copy link
Author

Yes, I installed it locally. Works great.
Thanks.

@MassyB
Copy link

MassyB commented Feb 18, 2020

Thanks again !
@avivl can you do a release ?

@avivl
Copy link
Contributor

avivl commented Feb 18, 2020

Not yet. I need more testing done

@MassyB
Copy link

MassyB commented Feb 19, 2020

When should we expect one ?

@avivl
Copy link
Contributor

avivl commented Feb 19, 2020

Probably in a couple of weeks, in the meantime, you can use the version that is in master

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants