Hi,
I am sorry I am very new to the splunk and I am struggling with the results I want to get.
I have a query that produces desired (kind of.. In visualization, months are still not in chronological order) result as bar chart without any effort. When I convert that to line chart, my grouping by month is removed and I get result for each day as seen below:
Query:
QUERY | eval Date=strftime('_time',"%Y-%m") | timechart count by Click | sort _time Desc
Visualization looks perfect as bar chart:
As soon as I select Line chart, My X-Axis displays chart by individual date and not grouped by month as seen below: 2:
Can someone please tell me how to group my data by month in a line OR any other chart?
Also how can I display my chart starting from latest?
Thanks
... View more