Hi Brendan: I am assuming you are referring to the post by Jaykumar and not me. Thank you. Yes, we have tried that process and the results match. However, building that calculation on different Trendline visuals is a cumbersome affair. Can you help us identify what needs to be corrected in the default REGR formula…

Hi Gianni: After reviewing the available formulas, you had pasted above, I thought the REGR function may be more in line with the SLOPE function. So, I tried this on a simple sales data set that shows in a Cross Tab viz : Products in Rows and Month in column. My goal would be to add the REGR calculation to this data.…

The idea of using the Forecast functions sounds interesting. However, in my experience with OAC, we seem to be able add this forecast feature only on charts. Can this function be added on a pivot table or a simple table viz? For eg: Lets say we have onhand data for 100 SKUs ( Inventory Items) over the last 12 months -…

An absolute must