Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] ))
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.
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
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.