I hope you’re all doing well.
I have a question regarding a timeseries graph I’m working on.
Currently, the graph displays the months as “01/01,” “01/02,” etc.
However, I’d like to have the months displayed as their full names, like “January,” “February,” and so on.
Here’s the query I’m using:
$__timeGroupAlias(paid, 1h, 0),
count AS "order"
`o`.`type` AS type,
CONCAT(DATE_FORMAT(`o`.`paid`, "%Y-%m"),'-01') AS paid,
COUNT(`o`.`id`) AS count
AND `o`.`paid` >= '2022-01-01'
) AS `order`
Thank you for your assistance.
Has anyone else faced a similar issue or could offer some guidance on how to accomplish this?
Except the above mentioned issue, I’ve encountered also another issue. As you can see in the graph although my table (see below) includes only the first day of each month, the graph is displaying dates between the months as well like 01/16, 15/02, 03/17 etc
Any help or suggestions would be greatly appreciated.
Can you please your screen shot, those seem like very odd dates
Thanks for answering. The table above was a sample.
Please see my current data:
So as you can see the actual data points with the dot are on the 1st of every month. the rest is just fill in data. that is just the way it does time series.
Dear @yosiasz thank you,
There is no way the graph to display only the first day of the month like 01/01, 01/02 …or just the name of the month ie Jan, Feb, etc.?
I think then it no longer becomes a
time series. in that case you want a different visualization
Hi @yosiasz thank you!
I managed to have a graph similar with what I wanted changing the time shift. I send it here for anyone who needs something like that.