forecast with Drill down dimension

[Heena]

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.

[NhanNguyen]

You are now hard-coding Month as your dimension. Try to replace it with your Drill-down dimension and see if it works.