Skip to Content
Sep 18, 2017 at 09:25 AM

Bucket in webi

119 Views Last edit Sep 21, 2017 at 08:24 AM 2 rev

Hi Experts,

I am facing a strange error:

We have following table with DTI(report level variable).

DTI<.40=Count([Query 2].[Lead Id] Where([DTI]<0.4))

DTI >= .40 & <=.45=Count([Query 2].[Lead Id] Where([DTI]<=0.45 And [DTI]>=0.4 )) ForEach([Case Completed MonYear])

It shows the values correctly.

However once I remove lead id from this it shows following

As you can see in above image we have a lead DTI>.7 and 1 in .5 & .7.

My report need the last table but its not showing the count correctly.

I tried using foreach on lead id or case completed mon year but it doesnt work.