Box plots are based on one metric and one attribute. They are supported only by data sources that use Composer connectors that support percentile calculations necessary for box plots.
Support for this feature by Composer connectors is shown in the following table.
Key:Y - Supported; N - Not Supported; N/A - not applicable
|Apache Phoenix Query Server (QS)||N|
|BigQuery||Y||If you need to access a BigQuery partition, explicitly include an alias for the built in partition column in your select clause, such as |
|Cloudera Search||N||The Apache Solr versions prior to 5.3 used by Cloudera Search do not have the percentile aggregations required for box plots built in.|
|Microsoft SQL Server||Y|
|Real Time Sales||Y|
|File Upload (Upload API)||Y|
Data from Fusion data sources can be used in box plots.
This topic describes:
To specify the color settings for a specific box plot using the Color sidebar:
Edit the visual you want to modify. See Edit Visuals.
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.
Configure the color settings as described below. As you change the color settings, the legend at the top of the Color sidebar shows how the legend will appear on the visual. Supported color specifications are described in Specify Colors.
Setting Description Legend Slide the bar to the right if you want the legend to be displayed on the visual or to the left to hide the legend. You can manually select the color for each color in the legend using the color selector. Color Attribute Select the attribute that affects the segment color in the visual. Group By Color Palette If a color palette is specified for this visual type in the data source defaults, select the color palette for this specific visual. If a color range is selected this visual type in the data source defaults, this setting is not available. Select the Inherit from theme checkbox to use the color palette specified by the theme.
Close the Color sidebar and the color settings are dynamically applied to the visual.
Select to save the dashboard and the visual with its updated settings.