How do I reorder the columns with this report? I want it to be:
date - product - imps - clicks - category
If I reorder the stats command, it fails and says :
Error in 'stats' command: The argument 'date' is invalid.
Here's the original query:
sourcetype=imp-log host=*.prod.fb.local site_id=xxxx earliest=-1d@d latest=-0d@d
| lookup siteproduct siteproductid as siteproduct_id siteid as site_id OUTPUTNEW productid as product productcategory as category
| eval date = imp_date
| stats count(eval(imp_action="imp")) as "imps", count(eval(imp_action="click")) as "clicks" by product, category, date
... View more