Hi,
I have to show the forecast of count(BUG_ID), for the dates---> Year-Quarter-Month-Date ,Drill down.
i found the below solution for forecast, and it worked for one date field for example month.
https://community.qlik.com/t5/New-to-Qlik-Sense/FORECAST-and-TREND-function-of-Excel-in-Qlik-Sense/t...
the measure expression, i used for month field(dimension) is as below,
=if(Count(BUG_ID),Count(BUG_ID),
linest_m(total aggr(if(Count(BUG_ID),Count(BUG_ID)),
[Month]),[Month])*
only([Month])
+linest_b(total aggr(if(Count(BUG_ID),Count(BUG_ID)),
[Month]),[Month]))
Can anyone help me with measure expression, that works to forecast count(BUG_ID) with the Drill down(Year-Quarter-Month-Date) ?
i have created the drill-Down Dimension---> Year-Quarter-Month-Date.
