# Dashboards **URL:** https://community.influxdata.com/c/influxdb2/visualize/8.md?page=1 [Latest](https://community.influxdata.com/latest.md) · [Categories](https://community.influxdata.com/categories.md) · [Tags](https://community.influxdata.com/tags.md) **Page:** 2 --- ## [How to find big csv file for test or generate one?](https://community.influxdata.com/t/how-to-find-big-csv-file-for-test-or-generate-one/34662)
**Author:** [@Mark\_influx](https://community.influxdata.com/u/Mark_influx)\ **Replies:** 0\ **Last updated:** [June 21, 2024, 9:22am UTC](https://community.influxdata.com/t/how-to-find-big-csv-file-for-test-or-generate-one/34662 "2024-06-21T09:22:25Z")
how to find big csv file for test or generate one? i search 3gb csv or how generate one? this is a test for replica i try with this but non import data : cat prova.sh #!/bin/bash Variabili #D:ATABASE\_NAME=“myDatabas… --- ## [Count number of measurements of a bucket](https://community.influxdata.com/t/count-number-of-measurements-of-a-bucket/34360)
**Author:** [@AnonymousWebHacker](https://community.influxdata.com/u/AnonymousWebHacker)\ **Replies:** 2\ **Last updated:** [June 16, 2024, 3:50pm UTC](https://community.influxdata.com/t/count-number-of-measurements-of-a-bucket/34360 "2024-06-16T15:50:20Z")
I was searching all the documentation (forgive me if I didn’t find it) and I couldn’t find a way to make a request to the database, and it would return, for example, the number of measurements that a bucket has. Found a… --- ## [How to sum some fields and display it in line chart?](https://community.influxdata.com/t/how-to-sum-some-fields-and-display-it-in-line-chart/34302)
**Author:** [@alifyaza](https://community.influxdata.com/u/alifyaza)\ **Replies:** 1\ **Last updated:** [May 22, 2024, 4:10pm UTC](https://community.influxdata.com/t/how-to-sum-some-fields-and-display-it-in-line-chart/34302 "2024-05-22T16:10:42Z")
I want to add a line chart displaying three lines: total\_data (total\_data\_bytes), rx (rx\_data\_bytes), and tx (tx\_data\_bytes). I use this query below at first: from(bucket: "wifi") |\> range(start: v.timeRangeStart, sto… --- ## [Moving out of InfluxDB Datasource to Prometheus! Need some help](https://community.influxdata.com/t/moving-out-of-influxdb-datasource-to-prometheus-need-some-help/34376)
**Author:** [@akhan4u](https://community.influxdata.com/u/akhan4u)\ **Replies:** 1\ **Last updated:** [May 28, 2024, 7:07pm UTC](https://community.influxdata.com/t/moving-out-of-influxdb-datasource-to-prometheus-need-some-help/34376 "2024-05-28T19:07:55Z")
Hi Team, We are planning to move some of our grafana dashboards from Influx datasource to Prometheus. Since, We have multiple monitoring tools, we tend to streamline all of our monitoring into one tool (prometheus in th… --- ## [Question about WIndow Period/aggregateWindow](https://community.influxdata.com/t/question-about-window-period-aggregatewindow/34362)
**Author:** [@gatortech12](https://community.influxdata.com/u/gatortech12)\ **Replies:** 1\ **Last updated:** [May 28, 2024, 4:58pm UTC](https://community.influxdata.com/t/question-about-window-period-aggregatewindow/34362 "2024-05-28T16:58:07Z")
Just trying to understand what this WIndow Period/aggregateWindow does. When I change the time period it tends to change the value of the mean that im taking. If my understanding is correct it takes the point at every 15… --- ## [Grouping Data per Day/Week/Month/Year](https://community.influxdata.com/t/grouping-data-per-day-week-month-year/34275)
**Author:** [@Nicolas\_Lauinger](https://community.influxdata.com/u/Nicolas_Lauinger)\ **Replies:** 3\ **Last updated:** [May 16, 2024, 6:37pm UTC](https://community.influxdata.com/t/grouping-data-per-day-week-month-year/34275 "2024-05-16T18:37:54Z")
Hello everyone, I’m new to the Influx world. I’ve been saving my values from the PV system for a few days now and visualizing them in Grafana. I have managed the simple things well. But now I’m reaching my limits. For … --- ## [No data collection after laptop restart](https://community.influxdata.com/t/no-data-collection-after-laptop-restart/34161)
**Author:** [@bro32](https://community.influxdata.com/u/bro32)\ **Replies:** 1\ **Last updated:** [May 8, 2024, 2:04pm UTC](https://community.influxdata.com/t/no-data-collection-after-laptop-restart/34161 "2024-05-08T14:04:32Z")
Hello there! I am pretty new to InfluxDB and data collection in general and I got the problem that after the restart of my laptop (I use Ubuntu) the InfluxDB bucket/dashboard doesn’t show new data, only the data that was… --- ## [Create a new column of data by getting the data from the operation data in other columns](https://community.influxdata.com/t/create-a-new-column-of-data-by-getting-the-data-from-the-operation-data-in-other-columns/33899)
**Author:** [@EBA](https://community.influxdata.com/u/EBA)\ **Replies:** 1\ **Last updated:** [April 15, 2024, 4:35pm UTC](https://community.influxdata.com/t/create-a-new-column-of-data-by-getting-the-data-from-the-operation-data-in-other-columns/33899 "2024-04-15T16:35:47Z")
Hello! I am new in InfluxDB and I am a little lost. I would like to know if it is possible to create a new column of data by getting the data from the operation data in other columns. Like in excel, for example: I w… --- ## [Apache access\_log duration aggregation by request URL](https://community.influxdata.com/t/apache-access-log-duration-aggregation-by-request-url/21992)
**Author:** [@Voodoom](https://community.influxdata.com/u/Voodoom)\ **Replies:** 5\ **Last updated:** [April 8, 2024, 8:47pm UTC](https://community.influxdata.com/t/apache-access-log-duration-aggregation-by-request-url/21992 "2024-04-08T20:47:07Z")
Hi, I started to migrate my companies metrics from InfluxDB V1 to V2, but there is this one query I’m totally lost and hopefully anyone can give me hint. The query: SELECT mean("duration") FROM "autogen"."apache\_acces… --- ## [Candlestick, Box chart/plot in Influx UI](https://community.influxdata.com/t/candlestick-box-chart-plot-in-influx-ui/33815)
**Author:** [@va2dim](https://community.influxdata.com/u/va2dim)\ **Replies:** 2\ **Last updated:** [April 4, 2024, 2:05pm UTC](https://community.influxdata.com/t/candlestick-box-chart-plot-in-influx-ui/33815 "2024-04-04T14:05:59Z")
I am using InfluxDB v2.7.0 & UI from Influx. Interesting in data visualization using Candlestick,Box chart/plot in Influx UI (data example like @scott speaking in https://youtu.be/h6KYk17FBNk?list=PLEM0QD2CHxaJbAV1DTE8C… --- ## [Dynamically Selecting Time Ranges in InfluxDB Flux Queries: Error and Solutions](https://community.influxdata.com/t/dynamically-selecting-time-ranges-in-influxdb-flux-queries-error-and-solutions/33794)
**Author:** [@Madhurima\_Rawat](https://community.influxdata.com/u/Madhurima_Rawat)\ **Replies:** 2\ **Last updated:** [April 3, 2024, 5:12pm UTC](https://community.influxdata.com/t/dynamically-selecting-time-ranges-in-influxdb-flux-queries-error-and-solutions/33794 "2024-04-03T17:12:51Z")
I’m using InfluxDB to store time-series data and Flux for querying. I have a scenario where I need to dynamically select start and end times based on specific conditions for each sensor and motif. However, it seems that … --- ## [Graphing out hourly values into daily values](https://community.influxdata.com/t/graphing-out-hourly-values-into-daily-values/33767)
**Author:** [@Noah](https://community.influxdata.com/u/Noah)\ **Replies:** 1\ **Last updated:** [April 2, 2024, 12:51pm UTC](https://community.influxdata.com/t/graphing-out-hourly-values-into-daily-values/33767 "2024-04-02T12:51:40Z")
Hello all, I currently have a graph where I hourly send a value of counts. I want to be able to view these hourly on the graph like I already do but also group up all of the values into daily values so the graph would sh… --- ## [Dashboard variables suddenly stopped working](https://community.influxdata.com/t/dashboard-variables-suddenly-stopped-working/33554)
**Author:** [@leegrs](https://community.influxdata.com/u/leegrs)\ **Replies:** 1\ **Last updated:** [March 21, 2024, 8:43pm UTC](https://community.influxdata.com/t/dashboard-variables-suddenly-stopped-working/33554 "2024-03-21T20:43:34Z")
I don’t see anything in journal log and when running the queries to get the variables values there is no issue. --- ## [Using a dashboard variable in a query](https://community.influxdata.com/t/using-a-dashboard-variable-in-a-query/27856)
**Author:** [@leeprevost](https://community.influxdata.com/u/leeprevost)\ **Replies:** 3\ **Last updated:** [March 5, 2024, 1:21pm UTC](https://community.influxdata.com/t/using-a-dashboard-variable-in-a-query/27856 "2024-03-05T13:21:14Z")
I’m trying to use a simple influx variable in my query which allows for user input to my dashboard. Consider a simple mapped variable called “threshold”: high,"3.0" low,"2.0" mid,"2.5" Now, the question is how do I us… --- ## [404 page not found on http://ServerIP.address:8086](https://community.influxdata.com/t/404-page-not-found-on-http-serverip-address-8086/33190)
**Author:** [@Herrx](https://community.influxdata.com/u/Herrx)\ **Replies:** 2\ **Last updated:** [February 22, 2024, 8:50am UTC](https://community.influxdata.com/t/404-page-not-found-on-http-serverip-address-8086/33190 "2024-02-22T08:50:05Z")
Hey, I installed the influxDB 2.7.4 on my ubuntu sytem. curl -O https://dl.influxdata.com/influxdb/releases/influxdb2\_2.7.4-1\_amd64.deb sudo dpkg -i influxdb2\_2.7.4-1\_amd64.deb Now the system ist running after. sudo … --- ## [Calculate the total power usage](https://community.influxdata.com/t/calculate-the-total-power-usage/25380)
**Author:** [@bceyresy](https://community.influxdata.com/u/bceyresy)\ **Replies:** 4\ **Last updated:** [February 6, 2024, 10:50am UTC](https://community.influxdata.com/t/calculate-the-total-power-usage/25380 "2024-02-06T10:50:00Z")
Hi, I have a live power reading which is coming in every so many seconds in Kw. Is there a way to calculate the total usage over a day? Not sure if SUM() would just add up all the data points ? would the best way to be… --- ## [Shelly 3EM dashboard](https://community.influxdata.com/t/shelly-3em-dashboard/32916)
**Author:** [@makis\_solomos](https://community.influxdata.com/u/makis_solomos)\ **Replies:** 1\ **Last updated:** [January 29, 2024, 7:43pm UTC](https://community.influxdata.com/t/shelly-3em-dashboard/32916 "2024-01-29T19:43:04Z")
I know this question has been asked many times but I couldn’t find a straight answer. I have a shelly 3EM that sends data directly to influxDB. I want to create a dashboard with the hourly and daily consumption (from a… --- ## [Two measurements, but graph only arithmetic mean of them](https://community.influxdata.com/t/two-measurements-but-graph-only-arithmetic-mean-of-them/32906)
**Author:** [@tomeq82](https://community.influxdata.com/u/tomeq82)\ **Replies:** 1\ **Last updated:** [January 29, 2024, 7:29pm UTC](https://community.influxdata.com/t/two-measurements-but-graph-only-arithmetic-mean-of-them/32906 "2024-01-29T19:29:36Z")
I was searching for an answer for this rather easy problem but surprisingly I was unable to find solution. I have two measurements, from two the same type sensors, they just differ by the id. Both of them have sligtly d… --- ## [Best practice to rename fields based on \_field and tag set values](https://community.influxdata.com/t/best-practice-to-rename-fields-based-on-field-and-tag-set-values/32872)
**Author:** [@florianber](https://community.influxdata.com/u/florianber)\ **Replies:** 1\ **Last updated:** [January 22, 2024, 5:05pm UTC](https://community.influxdata.com/t/best-practice-to-rename-fields-based-on-field-and-tag-set-values/32872 "2024-01-22T17:05:07Z")
I want to rename filtered data series that I have prepared for a Grafana dashboard panel based on tag values. Basically, I store temperatures and other sensor data from indexed locations. To identify each sensor, I defin… --- ## [InfluxQL not giving the expected result (querying InfluxDB through shell)](https://community.influxdata.com/t/influxql-not-giving-the-expected-result-querying-influxdb-through-shell/32886)
**Author:** [@Tristan](https://community.influxdata.com/u/Tristan)\ **Replies:** 5\ **Last updated:** [January 22, 2024, 11:40am UTC](https://community.influxdata.com/t/influxql-not-giving-the-expected-result-querying-influxdb-through-shell/32886 "2024-01-22T11:40:19Z")
SELECT value, codeDevice FROM myMeasurement gives at least these results : ┏━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━┓ ┃ index ┃ time ┃ value ┃ codeDe… --- ## [\[Newbie\] Graph that converts watts/hr to watts](https://community.influxdata.com/t/newbie-graph-that-converts-watts-hr-to-watts/32807)
**Author:** [@rthorntn](https://community.influxdata.com/u/rthorntn)\ **Replies:** 0\ **Last updated:** [January 15, 2024, 6:00am UTC](https://community.influxdata.com/t/newbie-graph-that-converts-watts-hr-to-watts/32807 "2024-01-15T06:00:38Z")
Hi, I’m new to all this and I hope this makes sense, I’m feeding my home power usage (watts/hour) into InfluxDB every second, so I want to figure out my actual power usage as a 30 minute average (my “wholesale” power co… --- ## [Trying to create a chart which represents the sum of some other charts ALMOST works](https://community.influxdata.com/t/trying-to-create-a-chart-which-represents-the-sum-of-some-other-charts-almost-works/32714)
**Author:** [@Tristan](https://community.influxdata.com/u/Tristan)\ **Replies:** 0\ **Last updated:** [January 4, 2024, 2:09pm UTC](https://community.influxdata.com/t/trying-to-create-a-chart-which-represents-the-sum-of-some-other-charts-almost-works/32714 "2024-01-04T14:09:38Z")
Hi, I have these charts representing the values of a dozen different devices over time. These measures are stored in the same “Teleinformation” measurement : For example, at 9:04:00, I have one value per device whic… --- ## [Sign in two dashboards at the same time, same host but different ports](https://community.influxdata.com/t/sign-in-two-dashboards-at-the-same-time-same-host-but-different-ports/32647)
**Author:** [@breadum](https://community.influxdata.com/u/breadum)\ **Replies:** 0\ **Last updated:** [December 28, 2023, 8:19am UTC](https://community.influxdata.com/t/sign-in-two-dashboards-at-the-same-time-same-host-but-different-ports/32647 "2023-12-28T08:19:43Z")
I have two running docker instances of influxdb2 on the same machine. Whenever I try to connect to one of localhost:12345, localhost:12346, my session gets lost from the other web dashboard that I already signed in. H… --- ## [Impossible to update payment method](https://community.influxdata.com/t/impossible-to-update-payment-method/32621)
**Author:** [@curquiza](https://community.influxdata.com/u/curquiza)\ **Replies:** 0\ **Last updated:** [December 26, 2023, 10:57am UTC](https://community.influxdata.com/t/impossible-to-update-payment-method/32621 "2023-12-26T10:57:22Z")
Hello I’m trying to change my payment method, but I’m facing this error without knowing what to do: \[ReCaptcha\_Validation\_Failed\] The request is temporarily blocked due to security reason. Reference id: 4B71491AB21D0C3… --- ## [How to filter noise from a time-series graph?](https://community.influxdata.com/t/how-to-filter-noise-from-a-time-series-graph/32358)
**Author:** [@rzieber](https://community.influxdata.com/u/rzieber)\ **Replies:** 2\ **Last updated:** [November 30, 2023, 4:44pm UTC](https://community.influxdata.com/t/how-to-filter-noise-from-a-time-series-graph/32358 "2023-11-30T16:44:04Z")
I’m using Grafana to create a time-series graph of snow depth data stored in an InfluxDB database. I’m on a PC running Grafana version 7.1.1 (this configuration was set up by my team at work so I can’t update without per… --- ## [How to count row in a table?](https://community.influxdata.com/t/how-to-count-row-in-a-table/31909)
**Author:** [@Justify5036](https://community.influxdata.com/u/Justify5036)\ **Replies:** 4\ **Last updated:** [November 21, 2023, 7:40am UTC](https://community.influxdata.com/t/how-to-count-row-in-a-table/31909 "2023-11-21T07:40:15Z")
Hi, I am an absolute beginner with Telegraf and InfluxDB. Thanks in advance for your help. Here’s my current situation: I have configured Telegraf to return information about processes starting with the name “GAME”. \[\[… --- ## [Performant way for conditional filter](https://community.influxdata.com/t/performant-way-for-conditional-filter/32087)
**Author:** [@norkler](https://community.influxdata.com/u/norkler)\ **Replies:** 2\ **Last updated:** [November 15, 2023, 12:09am UTC](https://community.influxdata.com/t/performant-way-for-conditional-filter/32087 "2023-11-15T00:09:59Z")
Hi there, I’m new to Flux and try to visualize my data in an easy way to the user. I’ve a lot of measurements and want to give the user the ability to filter for measurement (devicename in my case), customer and consum… --- ## [Keep numbers of virtual machines to store in a Time series](https://community.influxdata.com/t/keep-numbers-of-virtual-machines-to-store-in-a-time-series/31992)
**Author:** [@Peter\_C](https://community.influxdata.com/u/Peter_C)\ **Replies:** 1\ **Last updated:** [November 12, 2023, 8:33am UTC](https://community.influxdata.com/t/keep-numbers-of-virtual-machines-to-store-in-a-time-series/31992 "2023-11-12T08:33:29Z")
I have bucket that holds numbers of VMs across several datacenters. I want to log how many VMs I have in a Time series dashboard. This is my flux query: How can I store the numbers of VMs once an hour and log the ti… --- ## [hourSelection() not working in Grafana](https://community.influxdata.com/t/hourselection-not-working-in-grafana/16477)
**Author:** [@Marti\_B](https://community.influxdata.com/u/Marti_B)\ **Replies:** 7\ **Last updated:** [November 9, 2023, 6:32am UTC](https://community.influxdata.com/t/hourselection-not-working-in-grafana/16477 "2023-11-09T06:32:42Z")
So I have this Flux query: from(bucket: v.defaultBucket) |\> range(start: v.timeRangeStart, stop: v.timeRangeStop) |\> filter(fn: (r) =\> r\[“\_measurement”\] == “Energy”) |\> filter(fn: (r) =\> r\[“\_field”\] == “value”) |\> … --- ## [Data analysis and visualisation - InfluxDB 3.0](https://community.influxdata.com/t/data-analysis-and-visualisation-influxdb-3-0/31991)
**Author:** [@nowy](https://community.influxdata.com/u/nowy)\ **Replies:** 1\ **Last updated:** [October 30, 2023, 9:35am UTC](https://community.influxdata.com/t/data-analysis-and-visualisation-influxdb-3-0/31991 "2023-10-30T09:35:57Z")
Hello everyone, Just wondering: do you guys know if data analysis (cleaning, labeling etc) and data visualisation is possible with the new influxdb 3.0? Or know tools which are compatible with the newer version ? I’ve … [Previous page](https://community.influxdata.com/c/influxdb2/visualize/8.md) [Next page](https://community.influxdata.com/c/influxdb2/visualize/8.md?page=2)