Hi all,
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.
Example:
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