I want to Bring back only the Last 5 Days for my Backlog?

[jamiemcc]

Hi Guys,

Can anyone help me Limit the Last 5 days For my BL Date for the Below Script, Its driving me Crazy!!

sum({<[BL NetworkDay Flag]={1}>}aggr(
sum({<[BL NetworkDay Flag]={1}>}[BL Unassigned Tasks] * ([BL Average Task Time] / $(vBaseTaskTime)))

*

if(vMarketShare=1 and len(MarketShare)>0, MarketShare, 1)

, Locale, [BL Date] ))

[Nicole-Smith]

You can add the following into your set analysis:
[BL Date]={'>=$(=date(today()-5))'}

So it should look like this:
sum({<[BL NetworkDay Flag]={1}, [BL Date]={'>=$(=date(today()-5))'}>}aggr(
sum({<[BL NetworkDay Flag]={1}, [BL Date]={'>=$(=date(today()-5))'}>}[BL Unassigned Tasks] * ([BL Average Task Time] / $(vBaseTaskTime)))
*
if(vMarketShare=1 and len(MarketShare)>0, MarketShare, 1)
, Locale, [BL Date] ))

Depending on what you have in vBaseTaskTime, you may need to add it into there as well.

[jamiemcc]

Hi Nicole,

Thanks for the Reply, Unfortunately that Brings back No Data Or dates. vBAseTime = 60.

sum({<[BL NetworkDay Flag]={1}>}aggr(
sum({<[BL NetworkDay Flag]={1}>}[BL Unassigned Tasks] * ([BL Average Task Time] / $(vBaseTaskTime)))

*

if(vMarketShare=1 and len(MarketShare)>0, MarketShare, 1)

, Locale, [BL Date]))

Jamie

[Nicole-Smith]

Can you post an example file?  I tried it with test data and it worked fine, so there must be something special about your data.