Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can someone tell how to do forecasting line chart for some financial data.
Thanks in advance.
I used:
if(SUM(Revenue),SUM(Revenue),
linest_m(total aggr(if(SUM(Revenue),SUM(Revenue)),Date),Date)*
only({1}Date)
+linest_b(total aggr(if(SUM(Revenue),SUM(Revenue)),Date),Date))
which uses the very simple y=mx+b to calculate the straight line. If you project your [Date] forward, the line will be projected forward as well.
This created a set "MMM-YYYY" of 12 months behind, 3 months ahead:
Let varMinDate = Num(MonthStart(AddMonths(Today(),-12)));
TempCalendar:
LOAD
Date(AddMonths($(varMinDate), + RecNo() - 1),'MMM-YYYY') as Date
AutoGenerate 15;
Hi,
Go through the below attached qvw files it might help u.