A “worksheet” is where you’ll be adding the time-series you want to visualize from the connected data sources.
It is composed of the following areas:
- A navigation bar, to manipulate the worksheet’s time range.
- One or more charts where the time-series data are plotted.
- A table view listing the various series that were added to the worksheet.
- 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
Similarly to sources, clicking on the background chart icon on an empty pane will also add a new worksheet.
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
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.
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
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.
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.
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.
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.
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.
Changing the layout¶
By default, multiple charts on a single worksheet are displayed one above the other, with their timeline (X axis)
You can change that default “stacked” layout to an “overlay” layout using the icon to the far right of the navigation bar.
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.
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¶
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.
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.
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.
Series order is important in area charts and stacked area charts as it affects the aspect of the graph.
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
You can also hide series from a chart without removing them by unchecking the box next to their title in the bottom table.
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.
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.
Navigating the chart¶
Selecting the time range¶
Use the time range picker to select the worksheet current time range.
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…)
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
Auto Scale Y Axis option in the
Chart Properies panel and set the desired values in the fields beneath it.
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.
You can also quickly toggle the horizontally and vertically crosshair marker by holding respectively 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.
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.
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.
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
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.
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.