Bars: Histograms

Histograms are based on one metric and one attribute. They are supported only by data sources that use Composer connectors that support the calculations necessary for histogram visuals with integer values.

Support for this feature by Composer connectors is shown in the following table.

Key: P - Supported; O - Not Supported; N/A - not applicable

Connector Supported?
Amazon Redshift P
Amazon S3 P
Apache Drill P
Apache Phoenix P
Apache Phoenix Query Server (QS) P
Apache Solr P
BigQuery P
Cloudera Impala P
Cloudera Search O
Couchbase P
Dremio P
Elasticsearch 6.0 P
Elasticsearch 7.0 P
Flat File P
HDFS P
Hive P
MemSQL P
Microsoft SQL Server P
MongoDB O
MySQL P
Oracle P
PostgreSQL P
Presto P
Real Time Sales P
SAP Hana P
SAP IQ P
Snowflake P
Spark SQL P
Teradata P
TIBCO DV P
Upload API P
Vertica P

Data from Fusion data sources can be used in histograms.

This topic describes:

Configuring Default Histogram Settings for a Data Source

To configure default histogram settings for a data source configuration:

  1. Edit the appropriate data source configuration. See Editing a Data Source Configuration.

  2. Select the Visuals tab in the data source configuration wizard.

  3. On the Standard subtab of the Visuals tab, select Bars: Histogram.

    If you want to be able to display the data collected by this data source configuration as a histogram, make sure the Bars:Histogram checkbox is selected.

    Default histogram settings appear on the right side of the page.

  4. Configure the default settings as follows:

    Setting Description
    Group By

    Select the attribute by which the data should be grouped.

    Number of bars

    Specify the number of bars:

    • Auto - if you select this option, the bins for all your data set will be built and corresponding bars will be displayed.
    • Limit to - specify the maximum number of bars to be displayed on your visual.
    • Bar interval - specify the bar interval for your visual.
    Axis values

    Specify the types of values to be shown on the visual:

    • Absolute - select this option if you want to see the exact values.
    • Relative - select this option if you want to see the values in %.
    Show Cumulative Line Select this checkbox if you want the cumulative line to be displayed on your visual.
    Cumulative Line Color Select the color for the cumulative line on your visual.
    Bins Color Select the color for the bins on the visual.
  5. Select .

Configuring Settings for a Specific Histogram

To change the settings for a specific histogram:

  1. Edit the histogram you want to modify. See Editing Visuals.

  2. If you are editing the visual in a dashboard, select Edit Visual from the visual drop-down menu. The sidebar menu for the visual appears.

    If you are editing the visual from the Visual Gallery, the sidebar appears to the right of the visual.

  3. Select on the sidebar menu. The Histogram Settings sidebar for the visual appears.

  4. Alter the settings as needed:

    Setting Description
    Number of Bars

    Specify the number of bars:

    • Auto - if you select this option, the bins for all your data set will be built and corresponding bars will be displayed.
    • Limit to - specify the maximum number of bars to be displayed on your visual.
    • Bar interval - specify the bar interval for your visual.
    Labels Slide the Append Absolute Values, and Append Relative Values sliders on (to the right) to enable these label options.
  5. Select to save the dashboard and the visual with its updated settings.

Configuring Colors for a Specific Histogram

To specify the color settings for a specific histogram using the Color sidebar:

  1. Edit the visual you want to modify. See Editing Visuals.

  2. If you are editing the visual in a dashboard, select Edit Visual from the visual drop-down menu. The sidebar menu for the visual appears. If you are editing the visual from the Visual Gallery, the sidebar appears to the right of the visual.

    Select on the sidebar menu. The Color sidebar for the visual appears.

  3. Configure the color settings as described below. Supported color specifications are described in Specifying Colors.

    Setting Description
    Bins Color

    Select the color for the bins on the visual.

    Cumulative Line Color Select the color for the cumulative line on your visual.
  4. Close the Color sidebar and the color settings are dynamically applied to the visual.

  5. Select to save the dashboard and the visual with its updated settings.