Hi
my data is .csv file manually uploaded to Splunk cloud. there are columns for year, month, week numbers.
I write below search to generate line chart to see weekly trend.
index="price"
Series="abc"
Form="1"
Product_Name="white"
|eval Year.Week = Year."-w".Week."-month".Month
|stats max(Price) AS max
median(Price) AS median
min(Price) AS min
median(sp) AS sp.com by Year.Week
But the result is presented in this order:
2017-w1-month1
2017-w10-month3
2017-w11-month3
2017-w2-month1
I want it in correct order:
2017-w1-month1
2017-w2-month1
...
2017-w9-month3
2017-w10-month3
...
Please help. I'm new in Splunk
... View more