BusinessObjects Board

Webi not grouping by/counting correctly

building reports webintelligence
#1

Hello,

I’m trying to create a simple report that displays number of sales that occurred by date, but the count and grouping does not seem to be functioning correctly. The count of SaleID is a calculated measure in the universe with the aggregated projected function set to count.

SELECT Date, Count(SaleID)
FROM Sales
GROUP BY Date

Webi only displays a count of 1 sale for each date, but when I drop the same code into my SQL editor and run directly on the DB, it acts as expected with multiple sales per date.

This seems like it should be really simple, but I can’t seem to figure out what’s going on. I’m stumped. Any help would be greatly appreciated.

Rampancy :us: (BOB member since 2011-05-31)

#2

Projected aggregation should be set as Sum, not count.
Oldie, but good here:-

https://bobj-board.org/t/107995/6

Mak 1 :uk: (BOB member since 2005-01-06)

#3

Sigh. :hb:

Thank you. I haven’t had my coffee yet.

Rampancy :us: (BOB member since 2011-05-31)

#4

Enjoy :mrgreen: .

Mak 1 :uk: (BOB member since 2005-01-06)