(v22) Bars: Histograms

Bars: Histograms

Histograms require only one metric (number). The metric data range is divided into intervals and the metric values that fall within each interval are counted. The histogram plots the value counts (Volume) against the metric intervals.

Histograms 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:Y - Supported; N - Not Supported; N/A - not applicable

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

Data from Fusion data sources can be used in histograms.

This topic describes:

• Configure Settings for a Specific Histogram
• Configure Colors for a Specific Histogram

Configure Settings for a Specific Histogram

To change the settings for a specific histogram:

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

2. If you are editing the visual in a dashboard, select Settings 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
   Show Cumulative Line	Select to enable the cumulative line to be displayed on your visual.
   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.
   Y-Axis Labels	Select Absolute Values, or Relative Values to use absolute or relative values.

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

Configure 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 Edit Visuals.

2. If you are editing the visual in a dashboard, select Settings 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 Specify 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.