Override Data Interval Expression

Neill, you are correct that this feature is not documented in the Help system. I will report that deficit.

In the REPORT DESIGN/Histogram Page Properties, Data tab, the Data Interval is a straight numeric value that sets the width of equal-width ranges/bins for frequency and count distribution.

The Override Data Interval Expression property, I believe, allows you to set conditions to determine what the even interval value will be, but I am not sure it will allow unequal-width ranges/bins to be set.

For example, an expression such as

<<IIf(<<Histogram_Count>> > 25,10)>>

in the Override Data Interval Expression property would test the data population count in the histogram output, and override the entry in the Data Interval property, substituting 10 for the data interval whenever the histogram count value is greater than 25. If the count is less than or equal to 25, the entry in the Data Interval property would be used to determine the width of ranges/bins. 

However, the overridden interval value would still produce equal-width ranges/bins on the histogram. Has anyone else in the community used the Override Data Interval Expression property to produce unequal-width ranges/bins on a gINT Histogram?

Neill, you are correct that this feature is not documented in the Help system. I will report that deficit.

In the REPORT DESIGN/Histogram Page Properties, Data tab, the Data Interval is a straight numeric value that sets the width of equal-width ranges/bins for frequency and count distribution.

The Override Data Interval Expression property, I believe, allows you to set conditions to determine what the even interval value will be, but I am not sure it will allow unequal-width ranges/bins to be set.

For example, an expression such as

<<IIf(<<Histogram_Count>> > 25,10)>>

in the Override Data Interval Expression property would test the data population count in the histogram output, and override the entry in the Data Interval property, substituting 10 for the data interval whenever the histogram count value is greater than 25. If the count is less than or equal to 25, the entry in the Data Interval property would be used to determine the width of ranges/bins. 

However, the overridden interval value would still produce equal-width ranges/bins on the histogram. Has anyone else in the community used the Override Data Interval Expression property to produce unequal-width ranges/bins on a gINT Histogram?

If you wish to define a number of specific ranges for a bar chart report, then you'll need to use the drawing entity Draw > Shapes > True Rectangle.  This approach involves writing an expression to calculate the rectangle height.  I used a Histogram report type, but made the gINT generated data frame invisible.

Pat, Phil,

Thank you for the responses. I am producing histograms which present frequency against classification ranges from BS 5930:1999+A2. For example, Undrained Strength (kPa) classification has the following ranges:

Extremely low = <10
Very low = 10 - 20
Low = 20 - 40
Medium = 40 - 75
High = 75 - 150
Very high = 150 - 300
Extremely high = 300 - 600

Most of these types of classifications have unequal ranges so the ability to apply this to a histogram would be useful.

Phil,

In the method you used - did you draw a True Rectangle for each range/bin and use a count expression for the height? Also, did you draw your own data frame and annotate the x and y axes manually?

Thank you,

Neill

>>did you draw a True Rectangle for each range/bin and use a count expression for the height?

yes

>>Also, did you draw your own data frame and annotate the x and y axes manually?

yes