BusinessObjects Board

Count in WEBI report level

building reports webintelligence
#1

Hi,

there is report calculating date diff from two query and it working correctly. like below

SONumber-----DispatchedDate—ReceivedDate—v_DateDiff
1234------------1/8/2022--------------15/8/2022--------14
1256------------2/8/2022--------------10/8/2022--------8
1278------------3/8/2022--------------11/8/2022--------8
1890------------3/8/2022--------------11/8/2022--------7

Now my requirement is get count SONumbers with V_DateDiff

14 -------1
8---------2
7--------1
-------------------------------1- 10

Any suggestion will be helpful

thanks in advance

#2

I’d expect you’d be able to use something like these two for your second table:
=[v_DateDiff] ForEach([SO Number]) for your DateDiff
=Count([SO Number];Distinct) for your counts
You might need to tweak the way that the block aggregates to get it working though.