Manipulating a Formula from Saved Search to Analytics Workbook
Answered
Hoping t o find Analytics wizard to help me think of a solution to an issue I am having in some design work I am performing. Details below, I think it could be an Analytics issue as I am able to create what I am after in Saved searches but can’t replicate in Analytics.
Idea: Creating a Supply Graph in Analytics Workbooks that shows aggregate inventory position on a daily basis determined by Sales Orders, Production Orders and Opportunities (utilised as forecasted demand).
I have been able to create this in a saved search. I am having issue replicating the formula into analytics.
Saved Search Formula:
sum/* comment */(CASE WHEN {type} LIKE ‘Production Order’ THEN {Quantity} ELSE ({Quantity}*-1) END) OVER(PARTITION BY {item} ORDER BY {trandate},{internalid},{linesequencenumber} ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
Best answer
Are you sure the /* comment */ trick works in suiteanalytics? I believe that is more of a hack in saved search than an actual feature of them.
Hi,
This is why I asked the question, as I need someone to assist converting it from a saved search hack to an analytics hack.