Hi tve, thanks for your detailed answer,
Though it seems
-
its not working with the <timestamp> + (<operation> <time range>) clause in MySQL, just tried different ways and exactly as you suggest but it doesnt do it.
-
if you show a 2 days time range and compare both days in the same graph, its not exactly what im looking for: to be more precise, i have an average hourly traffic rate (measured in mps ‘messages per sec’), and i report it in a weekly range,
4/2 to 9/2 week
hence what im looking is to get the past 15days-week MPS line (ie 27/1 to 4/2), BUT in the same time range as last week (, to show the last last 4/2 to 9/2 week mps line to compare),
a plugin does the trick, but it has several bugs and i need to do the same in a simple query (if doable)
this is what plug is does, and i need:
so how I do overlap both time lines in the same graph with MySQL queries without using that custom plugin (again, several bugs),
Thanks a lot for your advising,
j