I am trying to get all transactions for defined day in the past that have amount larger than the average transaction amount for the month before.
Show all transactions from one day (18.06.2014) that are larger than average transaction in 5th month.
Data is in .xml file and defined fields are: Date, Time, CC(number), Amount
I know how to get average transaction for a month:
My search earliest=-1mon@mon latest=-0mon@mon | stats avg(Amount) AS Average
How do I get result for one day in the past while comparing it to the month before?
I guess it should be a subsearch… Please help.
... View more