I am using Grafana 7.5.4 on to visualize values of my mysqlDB. [image] results in: [image] As I am grouping by week I also want the time axis to show the week only. Is there a way to achive this? If so…how :wink: ?

Hi @grafahna I think you might need to use the categorical Bar Chart: Bar chart Bar chart visualization This will let you use arbitrary strings, like Week 1 and so on…

Good day, took a whilke until I came back to my project…Txs for your hint. After upgrading to Grafana 8.3.3. I found the BarCharts but got stuck with another simple thing. Using a transformation I converted my Time to a string, which gives me one column per week. But how can i change the wierd stri…

@anon70503803 As I am still stuck I try to be more precise about my issue hoping to get help again. I need to analyze traffic data, currently 1.500.000 datasets (increasing by 40.000/week) stored in a MySQL DB. Graphs are working in general and Grafana performs pretty well, even zooming between dat…

hmmm…nobody knows? Looks like I have to go back to Excel :frowning: Database is MySQL btw

you could calculate the range of unix timestamps for each week and then set up value mapping for that range to week 30 or 31. You’d have to hardcode it but it would work…

X-axis to show week only

Grafana Configuration

grafahna April 4, 2022, 7:27am 5

hmmm…nobody knows? Looks like I have to go back to Excel
Database is MySQL btw

Show week number and date in X axis (grafana on postgres datasource)

Topic		Replies	Views
Non time data plotting Histogram Grafana	1	565	September 9, 2021
How to use calendarweek week(datetime) as time axis? Time Series Panel	1	2634	April 14, 2022
Show week number and date in X axis (grafana on postgres datasource) PostgreSQL visulazation , dashboard , time-series	2	474	August 1, 2025
Grafana with mysql show weekly result Grafana	1	485	October 3, 2018
How change name of the Axis X Grafana	6	904	August 16, 2021

X-axis to show week only

Related topics