Select and division

Hi, I recently update influxdb to the last version and since, I have an error (no error with the previous version).

My request is :
SELECT 1-last(“nb_tot_gsm_message”)/last(“nb_tot_message”) FROM “nb_gsm_message”, “nb_message”

I use grafana to visualize the result, and I have this message : Multiple Series Error

I suppose in the new version the is a trick with the divider.

Thanks.
David

@davidL I think the issue is that you are trying to select from multiple measurements. That is not supported in InfluxDB. What version are you running?

But FROM “nb_gsm_message”, “nb_message” is supposed to work for multiple measurements, isn’t it ?

I use the last version of influxdb v1.2, on v0.13 it was working.

@davidL I did not know that behavior was allowed! I’ve gone ahead and tested on both versions and it appears that this behavior is still in 1.2.4.

0.13.0

> insert foo v1=1,v2=2
> insert bar v1=1,v2=2
> select 1 - last(v1)/last(v2) from foo,bar
name: bar
---------
time	last_last
0	0.5

name: foo
---------
time	last_last
0	0.5

1.2.4

> insert foo v1=1,v2=2
> insert bar v1=1,v2=2
> select 1 - last(v1)/last(v2) from foo,bar
name: bar
time last_last
---- ---------
0    0.5

name: foo
time last_last
---- ---------
0    0.5