Histogram

Contents[Hide]

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

Histogram:

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

Histogram
Histogram

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:

HISTOGRAM(d0,s0,s1,Alignments...)

Histogram Range:

HISTOGRAMRANGE(d0,s0,s1,s2,s3,Alignments...)

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