Want to display Daily, Weekly and monthly data using tables and bar graph

[malickamranahmed]

I want to calculate the difference between my max and min value of each hour and want to visualize that on Grafana, The end result is to display each hour produced bottles or packs, I am reading the counter every 10 seconds (later on currently it is not 10 sec ) and logging it into my table with column name (packer_counter) along with the server time, Timestamp (with column name “time_st”). I want to use that timestamp for calculating the difference on an hourly basis and whenever the user selects the time range from grafana it should display the data of the given range on an hourly basis.

[mattabrams]

welcome to the forum, @malickamranahmed

this is a common question. Two bits of advice: check out our docs on time controls:

Use dashboards | Grafana documentation

and search this forum for similar questions, like this one:

Struggling with weekly bar chart and weekday names

Hi all, I´m using influxQL and want to display a bar chart which shows a bar for every week day. The bar should be labeled by the name of the day the data was submitted. As i noticed that this is not easy using influxQL I tried to achieve it by just adding the wording of the current day as a tag to the submitted value. That worked initially: [image] This is the corresponding table: [image] and the query is: SELECT (“income-day”),(“weekday”) FROM “income” with Transform outer join “Time…