What are you trying to achieve? I inserted 997 metrics into InfluxDB and want to visualize and count them correctly in Grafana. How are you trying to achieve it? Inserted 997 data points into the testUTC_1krows bucket in InfluxDB. Queried using Flux in Grafana: from(bucket: "testUTC_1krows") |> …

What does this give you? from(bucket: "datapoints") //or whatever your bucket name is called |> range(start: 1970-01-01T00:00:00Z, stop: now()) |> group() |> count()

@vaishaliburge Given that the query with the group() function gives you 1515 results, does that concur with what you were expecting? [image] The csv that you imported appears to have 3 fields: value, extra_column, and category that appeared as 3 separate tables in your original query. The group …

how is it grouping as total 1515, it should be 1000 per fields as I have inserted 1000 rows right or am i understanding influxdb wrongly ?? It means only 505 / field only has been inserted ? my conf I recently changed to [agent] interval = “10s” round_interval = true metric_batch_size = 500 me…

please post the content of your 2 csv files, modifying any sensitive data. We cant see what is in them remotely, I usually do have telepathic powers but today they are bit low :winking_face_with_tongue: also what @grant2 said after you ingest both csv files, and you do a stright raw query with the…

[image] vaishaliburge: Note : it is stored csv and not continous data. any help would be appriciated, also want to know if influxdb and grafana works for such data ?or just incoming data Also, maybe Telegraf+InfluxDB are overkill for what you are trying to do here. Seems like putting your .c…

It could be that the files are not static, they always get updated by another system

Yes will try out and paste my some of the csv data here. or attach. Give me sometime, will get back with updates hopefully something works :slight_smile: :crossed_fingers:

where is this plugin “Google sheets” is availabale in the grafana or influx? I cannot see in both of them, any more information on this would be helpfull :slight_smile:

It’s not a plugin for InfluxDB. It’s a datasource for Grafana. See my link above from yesterday. Let’s go back to basics…you have a .CSV file, correct? Does it get updated every hour, every day, etc.? Is your goal to just get that data into Grafana so you can view it, or do you intend to do ale…

Influxdb and Grafana retriving less number of rows than inserted

Grafana InfluxDB

ebabeshko March 17, 2025, 7:06pm 28

or even CSV + Infinity (like in this demo) would fit better

Topic		Replies	Views
Continue of : Influxdb and grafane retriving less number of rows than inserted InfluxDB	1	68	March 16, 2025
Grafana influxdb aggregation display a graph which doesn't match the db contents InfluxDB	2	658	April 30, 2020
Only 8 metrics from InfulDB Grafana	0	280	July 23, 2020
Only limited number of data points visible InfluxDB	2	1430	June 13, 2017
Table Panel: Filter and show data Table Panel influxdb , table-panel	19	20872	March 3, 2022

Influxdb and Grafana retriving less number of rows than inserted

Related topics