Yesterday I found out an issue (link to post) with chronograf charts, the first point was plotted but somehow hidden in the chart.
can you check if the problem is the same?
I’m not an expert of Chronograf but for what I Know:
About how to do that in a reliable way in chronograf, I’m not sure since it is not “time aware” (months, etc).
maybe with a combination of WHERE, LIMIT and ORDER BY but I don’t like it and I also doubt the result will be helpful (even because it will be sorted in the opposite way)
SELECT {...} WHERE time > now() - 186d GROUP BY {...} LIMIT 6 ORDER BY {tag/time} DESC
# in the worst case you have a range of 31d * 6 months = 186d
# LIMIT 6 -> only top 6 points returned
# ORDER BY {tag} DESC so the LIMIT gets only the 6 most recent points
There is still a problem, you can’t define what to put in the X axis, therefore you won’t be able to set visualize the result strictly by month.
EDIT: a solution based on a continuous query requires group by time() so it’s not a viable option in this case
