This function can only be used in formula visualizations, not formula measures.


The Histogram function assigns numeric values to bins and returns the counts.


You can also use the re-visualize to 'Calculate Histogram' to quickly generate the histogram. See Calculate Histogram.


Histogram Range:

The Histogram Range function assigns numeric values to bins and returns the counts based on start and end range of the distribution bins.

Histogram Range
Histogram Range

1. Syntax



Histogram Range:


2. Input

The Histogram function requires the following input:

  • d0 - The set of data values for which the histogram is calculated.

3. Parameters

The Histogram function uses the following parameters.

  • s0 - The size of the bins for the numeric values to be assigned to, optional. Enter 0 or null to calculate the bin size automatically.
  • s1 - A number representing the type of captions to describe the ranges, optional.
    • 0: The default value is 0 (Auto)
    • 1: ">=0 & <10, >=10 & <20"
    • 2: "0-10, 10-20"
  • s2 - The value used to start the range of the first bin. Input values smaller than this will not be counted in the result.
  • s3 - The value used to end the range of the last bin. Input values greater or equal to this will not be counted in the result.
  • Alignments... (One or More, Optional): Hierarchy placeholders to be used as the alignment axis.

4. Output

The Histogram function generates the following output:

  • Histogram - The Histogram result set.
  • The Histogram Range function generates the following output:

    • Histogram Range - The Histogram Range result set.

    5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri