How do I create a Histogram?

[DM101]

I have created a query that gives me two date fields, lets call them Invoice Date and Receipt Date. I have been able to calculate the difference between the two dates in a seperate column. Now I would like to create a graph that gives me a histogram on the occurences of each date calculated.

I have looked into using the Count aggregate function to count the occurences of each specific date, however, no matter how I try to write the formula, I either end up getting either "1" or the total number of dates.

Any help would be appreciated.

 

[blom0344]

Hello DM101,

This is a problem that is best described in the Business Objects users guide : chapter 15 Calculation contexts and extended syntax. If you do not specify a specific context all aggregate functions will aggregate automatically over the dimensions that are present in the block. (so there all 1's come from)
Page 344 of the users guide (in the PDF format) shows you an example of using a context to good effect.

 

[DM101]

blom0344,

Thanks for the reply; based on your response, I was able to finally get the number. My problem was how I was referencing the aggregate function to the objects. Once that was cleared up, the histogram was easy to build.

DM101