Hi!
I have a tag called „volk“ which goes from 1 to 9.
Is it possible to generate a table which looks like this :
volk_1 - date+time of last entry - value of last entry
volk_2 - date+time of last entry - value of last entry
volk_3 - date+time of last entry - value of last entry
…
this would be awesome 
To show the last X measurements I use thist query in Influx:
SELECT * FROM /.*/ ORDER BY time DESC LIMIT 10;Unfortunatly this is not answering my question, i need the last point of each taged “volk”
@zmaier, could you please try following.
SELECT * FROM gewicht ORDER BY time DESC LIMIT 1;
Thanks,
R. Singh
@zmaier, in spite of * use specific field name which you want to print here, rest of the query keep it same eg–>
SELECT field_name FROM gewicht ORDER BY time DESC LIMIT 1;
Thanks,
R. Singh
I’d rather use a query like this:
SELECT LAST("wert") FROM gewicht GROUP BY "volk"
I think, the timestamp gets in there by default, if you choose the right visualization.
