Hello, I am new to Grafana and have a problem mapping Time Series from a CSV file. my CSV file gives me the following values. [image] The values come from a ticket system. I have already picked out the necessary values that I want to display. Ticketnummer (Unique number for a ticket, Ticket ID…

welcome to the :grafana: community @p0se ! Is it possible to share the sample CSV data instead of a screenshot so the community can mock up your problem and give suggestions? Can you share which values you’ve already filtered in your CSV? For example, does the CSV data only include closed status ti…

in sql server SELECT count(1), concat(year(geshloschen),' (', count(1) ,')') AS metric FROM tickets GROUP BY year(geshloschen) [image]

If you are using Infinity datasource, you can use the UQL to do this for you. [image] The UQL query I am using parse-csv | extend "Geschlossen"=todatetime("Geschlossen") # converts the Geschlossen string to actual date | extend "rounded_date"=startofyear("Geschlossen") # rounds the Geschlossen t…

Thank you for your reply. shure, here you can find the CSV. https://drive.google.com/file/d/1o-n1dYxjvfI3t9SjOLo2QmgWkqOikSyr/view?usp=sharing The CSV file contains many more fields. I assumed that closed status is actually enough for my display. I have already set the type for three fields an …

Thank you also for your contribution. The CSV file is located locally on the Grafana server. But via infinity datasource I can’t find a way to add local files. Do you have an idea? Unfortunately I could not find anything in the documentation. Maybe there is another way to get the data. The CSV…

There is a config setting that you have to set to allow local files. Couldn’t you hit the api from grafana directly?

I have set this setting, otherwise I would not be able to open local .csv files. I just don’t know how to set a local file within the infinity datasource.

I only see two options. How to use csv stored locally in Grafana · yesoreyeram/grafana-infinity-datasource · Discussion #54 · GitHub [image] Maybe there is a programmatic way of embedding the csv file’s data into the inline Data section? Another thing that worked for me was I spun up a small nod…

Data from CSV in to Bar Charts

Grafana Graphite

smoofoperator March 3, 2023, 8:33pm 10

This might help: How to convert timestamp and then group by date?

Topic		Replies	Views
Create Bar Graph from CSV in Grafana Grafana bar-chart , datasource , csv	7	1723	February 22, 2024
CSV as DataSource General	28	46591	February 10, 2025
Unable to graph CSV data Dashboards csv	6	4007	November 25, 2022
Time series graph based on Start and End Time Grafana infinity-datasource , time-series	1	425	January 15, 2025
Download csv Sincronized Data Grafana csv , infinity-datasource , grafana	1	101	December 5, 2024

Data from CSV in to Bar Charts

Related topics