How to set absolute time range on a panel?

Grafana Dashboards
#1

I want set like this.

image
image850×493 72.9 KB

Ref. of image: https://www.researchgate.net/figure/The-bar-chart-showing-the-monthly-water-vapor-density-for-Ebonyi-state_fig4_323634510

Now, I set time shift of this month and I must edit every month.
example this month is June, I created graph by set this month, and created by set time shift 1M, and created by set time shift 2M, …

I want to set absolute time range: Jan, Feb, Mar, …, Dec of previous and this year.

#2

it looks like you might want to use the Bar Chart, which can use arbitrary strings on the x axis:

https://play.grafana.org/d/ktMs4D6Mk/5-bar-charts-and-pie-charts?orgId=1

See the docs for the data model that you will need to fit:

#3

Thank you for your answer but I still cannot do it

  1. I used Bar Chart already
  2. My data is 1 fieldname
  3. Storage data since about 5 months ago

I want separate my data to each month
I separate by set time shift but this method will set again every month

#4

What is your datasource? Could you please provide sample data for what you are trying to chart?

image
image971×785 36 KB

#5

My data source is InfluxDB.
I got data active power (kW) every 1 minute. After that, I calculated by /60 (kW to kWh).
I want to bring Total kWh each month show on bar chart like your graph.

Thank you

#6

Please provide the above in csv format?

#7

I generate csv format already but I do not know how to post csv format.
It show that
“Sorry, the file you are trying to upload is not authorized (authorized extensions: jpg, jpeg, png, gif, heic, heif, webp)”

#8

like following

_field,_value,_measurement
waterlevel,133.5,_ocean
#9

I do not know how to get that format but I create this on excel.
Data range: 01/03/2022 to 31/05/2022
I want to separate sum of March, April, May to bar graph

image
image417×660 7.4 KB

#10

type 3 ticks → ` <— before and after the data you want to post

image