Chart Types
bipp supports many different types of charts so you can select the perfect way to display your data. The chart selected at the last save is used when displaying it on the dashboard.
Chart Quick Start:
- Select your Measures and Dimensions by clicking to select or deselect the column in the Select Data pane.
- Select your chart type.
- Specify the number of rows to fetch (default: 1000).
- Fetch the data.
- Apply settings and filters.
Graph, Map and custom visualizations are not enabled by default. They are enabled through the Organization Settings option on the Settings menu. These options are only available to subscribed customers.
Table
This visualization displays the selected columns. Dimension columns have a blue header line, Measure columns have orange. Select Settings to modify the chart display.
Click Fetch to populate the chart:
You can change the number of rows to display, and page through the data:
Bar
This visualization displays a bar chart. By default the first non-aggregate column selected is mapped on the X-axis, while all selected aggregate columns are mapped on the Y-axis using different colors. The legend can be used to select a particular Measure or aggregate for visualization. Select Settings to modify the chart display.
Use the focus bar to focus the X axis:
Line
This visualization displays a line chart. By default the first non-aggregate column selected is mapped on the X-axis, while all the aggregate columns selected are mapped on the Y-axis using different colors. The legend can be used to select a particular Measure or aggregate for visualization. Select [Settings](/charts/chart_settings#line-lineimagesusing-bippline_iconpng to modify the chart display.
Use the Zoom slider bar to focus the X axis:
Scatter
This visulazation displays a scatter graph to help spot correlations in your data. Correlated data points fall along a line or curve. The better the correlation, the tighter the points hug the line. By default the first non-aggregate column selected is mapped on the X-axis, while all the aggregate columns selected are mapped on the Y-axis using different colors. The legend can be used to select a particular Measure or aggregate for visualization. Select Settings to modify the chart display.
Use the Zoom slider to focus the X axis:
Area
This visulazation displays an area graph. By default the first non-aggregate column selected is mapped on the X-axis, while all the aggregate columns selected are mapped on the Y-axis using different colors. The legend can be used to select a particular Measure or aggregate for visualization. Select Settings to modify the chart display.
Use the Zoom slider to focus the X axis:
Pie
This visualization displays a pie chart. By default the pie is created using the first aggregate column selected and labelled with values from the first non-aggregate column selected. The legend can be used to toggle visibility of the pie segments. Select Settings to modify the chart display.
Metric
This visualization displays single value data points or high level metrics. One suggested use is to add the metric to a dashboard to present a metric for user drilldown. Select Settings to modify the chart display.
GridChart
This visualization displays data across multiple dimensions in a pivot view. Server-side pivot is an option for the chart. Select Columns (Measures), and Rows (Dimensions). Select the type for the Grid Chart: default is a table, other options are horizontal bar, line, and a scatter graph. Select Settings to modify the chart display.
Grid Chart Color Options
There are color options for the horizontal bar, line, and a scatter graph types.
Change the color for representing the measure data. Select the drop down and pick a color.
You can assign a Column to use as the Colors for horizontal bar, line and scatter types.
- Select the dimension.
- In the Settings pane, click and hold the cursor on the dimension.
- Drag it to the Colors setting. Here is an example dragging Country to Colors:
Here is the same chart before and after dragging Country to Colors:
Boxplot
This visualization displays statistical data ased on the minimum (lowest line/whisker), first quartile (median of lower half), median (center line), third quartile (median of lower half), and maximum (highest line/whisker) value in the data set. Select Settings to modify the chart display.
Hover over a box to see the details:
Funnel
This visualization displays data as a funnel, going from highest to lowest. Funnels are typically used to visualize values across multiple stages in a process. Select Settings to modify the chart display.
Gauge
This visualization displays data as a gauge or speedometer chart. Gauges are typically used to show a where a single value is in relation to a range. The Dimension provides description and the Measure is the data point. Select Settings to modify the chart display.
HeatMap
This visualization displays a heat map, where your Measure is color coded across two Dimensions. Select Settings to modify the chart display.
Bullet
This visualization displays a bullet chart a dimension for the Y axis and five measures for Actual, Target, Range 1, Range 2, and Range 3. Select the five measures, then toggle the visibility for each of categories. Select Settings to modify the chart display.
Bubble
This visualization displays a bubble chart, showing your Measure graphed on two Dimensions. The bubble size is relative to the values. Select Settings to modify the chart display.
SparkLine
This visualization displays a SparkLine chart. This is similar to a stack of line charts. Select Settings to modify the chart display.
TreeMap
This visualization displays a treemap. Treemaps are used to display hierarchical data as nested rectangles. The rectangle size is proportional to the Dimension. An advantage is viewing thousands of color coded and relative size values in a small space, to search for patterns in your data. Select Settings to modify the chart display.
Map
This visualation displays a map. The chart uses columns with location coordinates or names of places to map the data. bipp uses the echarts library to render the map visualization. Select Settings to modify the chart display, including selecting a map type: Geo Map, Scatter Map, Network Map and Path Map. Here is an example of the Geo Map:
GMap
This visualization is used when there are dimensions based on Country + City or Latitude + Longitude. This uses Google maps in the background. Four different types of gmaps may be used based on available data. Select Settings to modify the chart display, including selecting a map type: Choropleth Map, Scatter Map, Network Map and Path Map. Here is an example of a Choropleth map:
Graph
The graph type of visualization is used to understand the relation or hierarchy between data points using nodes of a graph. Select Settings to select the source, target and value for the data.
Custom
The visualization is used to display a custom chart developed as a JavaScript extension with the bipp Extensions API. Select Settings to select the extension and set up the chart.