Skip to content

Worksheet pane

A “worksheet” is where you’ll be adding the time-series you want to visualize from the connected data sources.

worksheet

It is composed of the following areas:

  1. A navigation bar, to manipulate the worksheet’s time range.
  2. One or more charts where the time-series data are plotted.
  3. A table view listing the various series that were added to the worksheet.
  4. A property pane that shows the properties of currently selected chart.

Adding a worksheet

To add a worksheet to the current workspace, use the menu bar to navigate to Worksheet and select New Worksheet (or press Ctrl+W):

Show me

Similarly to sources, clicking on the background chart icon on an empty pane will also add a new worksheet.

Show me

Adding time series

In order to view and navigate the time series exposed by a connected source, you need to add it to a chart on a worksheet first.

To an existing chart

Drag the selected series onto the chart area in order to plot their data for the current time range of the worksheet

Show me

To a new charts

If you drop series from the tree onto the hilited area below the other charts, a new chart will be added the worksheet.

Show me

Charts created this way will automatically have theirs name, unit and chart type set according to the corresponding values in the source (if the source type provides that information).

Furthermore, if you drop more than one “sub-tree” (nodes with leaves) onto this area, an equal amount of new charts will be created, each populated with its own leaves

Show me

If you want to plot leaves from different hierarchical nodes onto the same chart, then you’ll have to first create the chart and explicitly drop the selected series onto its area.

Tip

All the actions described above can also be accomplished via a context menu instead of drag & drop; simply right-clik onto the selected series on the tree view and choose the action from the menu.

Show me

To a new worksheet

If you drop series from the tree onto the hilited area above the worksheet, a new tab is created and series are added to it.

Show me

Tip

If you drop a set of series directly onto the center icon on an empty worksheet pane, binjr will create a new one and add the new charts.

Show me

Editing the view

Once you’ve populated a worksheet with series you’re interested in, you can edit and change many of its aspects to tailor the view to your own needs and preferences.

Renaming a worksheet

You can change the name of a worksheet at any time by double-clicking on its tab.

Show me

Changing the layout

By default, multiple charts on a single worksheet are displayed one above the other, with their timeline (X axis) aligned perfectly.
You can change that default “stacked” layout to an “overlay” layout using the icon to the far right of the navigation bar.

Show me

Note

When viewed with an overlay layout, all series are plotted on the same chart (sharing a single X axis) but with individual Y axis. This is useful when you want to correlate visually two or more series that do not share the same unit and scale on the Y axis.

Editing a chart’s title and unit

You can change the title, unit name and prefix in the table list below the charts when the Chart Properties panel is available. To bring up the panel if it isn’t visible, click on the cog icon next to a chart’s entry in the table or at the top of its Y axis.

Show me

Note

Changing a chart’s unit prefix affects the way the scale of the Y axis automatically adapts its label:

  • Metric: Y axis graduations are divided by factors of 1000 and use metric prefixes (Kilo, Mega, Giga, etc…).
  • Binary: Y axis graduations are divided by factors of 1024 and use binary prefixes (Kibi, Mebi, Gibi, etc…).

Changing a chart’s aspect

Tip

Select the current chart by clicking on its title in the table list or on its Y axis.

You can change the visual representation of the current chart from the Chart Properties: pick-up a chart type in the drop down menu and adjust the lines weight and area’s opacity where applicable.

Show me

Note

Changing the chart’s type affect all series in the chart: it is not possible to have some series plotted as areas and other as lines in a single chart.
An approaching result can however be achieved using the “overlay” layout.

Changing series color

Click on the colored square next to a series’ legend in the bottom table to invoke a color picker and choose a new color for it.

Show me

Changing series order

To change the order in which a series are plotted onto the chart, drag it from the table view and drop it to the desired position.

Show me

Note

Series order is important in area charts and stacked area charts as it affects the aspect of the graph.

Note

You cannot drag series from one chart and drop it onto a different chart.

Removing series from a chart

To remove series from a chart, simply select the desired series and press the Delete key.

Show me

Tip

You can also hide series from a chart without removing them by unchecking the box next to their title in the bottom table.

Detaching tabs

Drag the tab handle of a worksheet and drop it outside of the worksheet area (or out of the binjr window entirely) to move this worksheet into a new, independent window.

Drop a detached tab inside the worksheet area of the main window to reattach it.

Show me

Context menu

All tab actions can also be access via a context menu, invoked by right-clicking on a tab handle, or via the “Worksheets” entry in the menu bar.

Show me

Selecting the time range

Use the time range picker to select the worksheet current time range.

Note

Invoke the time range picker by clicking the “From… To…” label at the center of the navigation bar.

Select the start and end dates for the time range using the calendar widget, or choose a preset time range (Last 24 Hours, Last 90 Days, Today, etc…)

Show me

Scaling the Y axis

By default, the Y axis for all charts is set to automatically adapt to the minimum and maximum values in the current time range.

You can however override this behaviour and fix both minimum and maximum display boundaries for the Y axis, by unchecking the Auto Scale Y Axis option in the Chart Properies panel and set the desired values in the fields beneath it.

Show me

Zooming

Toggle the horizontal or vertical crosshair axis using the icons on the left of the navigation bar, and zoom in by clicking on a chart and dragging the selection zone over the area you wish to zoom.

Tip

You can also quickly toggle the horizontally and vertically crosshair marker by holding respectively the Ctrl and Shift keys.

Show me

Note

In the stacked layout, zooming on the horizontal axis (i.e. the time line) applies to all charts one the worksheet, while vertical zoom only applies to the selected chart.

Int the overlay layout, zooming on both axis applies to all charts.

All changes to a worksheet’s time line are automatically remembered by the application, and you can navigate that history using the “backward” and “forward” arrows to the left of the navigation bar.

Show me

Linking worksheets timelines

All charts in a worksheet share a single time line, but worksheets are independent from one another; changing the current time on a worksheet does not affect the other.

It is sometime useful to navigate multiple worksheets conjointly (especially if they are in separate windows), however, in which case you can link two or more worksheets by clicking on the “chain” icon on a worksheet tab.

All changes to the selected time range in a worksheet will then by applied to all linked worksheets as well.

Show me

Note

You can link all the worksheets of a runtime instance of binjr, even the ones in separate windows, but you cannot link worksheets from different processes.

Edit and Presentation mode

A large portion of the application’s window is used up by the controls needed to help users compose a custom view of the data efficiently; the source pane, chart properties panel and detailed series table list.

All this real-estate, however, becomes wasted once the view is set up and all you want is to navigate it or present it to an audience.

In that case, switch to “presentation mode”: the chart area then takes up the totality of the application’s window, save fot the menu bar, and a condensed legend is display beneath each chart.

You can switch between “edit” and “presentation” modes at any time, by pressing the “board/pencil” icon on the navigation bar, or by pressing Ctrl+M.

Show me

Tip

While you cannot add new series to charts when in “presentation” mode, all the navigation features (time range picker, zoom, navigation history) are still available.

Taking snapshots

Press the “camera” icon on the navigation bar to capture the current worksheet as a static picture.

The resulting image, saved as a .png file, will always be captured as if in “Presentation mode” (i.e. without source pane, chart properties and condensed chart legends), and contain the entirety of the worksheet’s chart area even if scrolling is required to view it within the application.

The worksheet’s name and time range is also printed at the top of the snapshot.

Show me

snapshot