Charts, statistics, and thresholds

Charts and statistics turn raw measures into something you can read. This is where DataJot often becomes useful: instead of isolated values, you see an evolution.

Read a series detail

The chart detail for a series shows the chart for the current period. It can also show statistics, a threshold distribution, other series from the same category, and series using the same unit.

Take a “Living Room Temperature” series. Over one day, the chart can show hourly variation. Over one month, it can reveal a broader trend. The same data becomes more or less detailed depending on the selected period.

Understand statistics

DataJot can display minimum, maximum, average, median, sum, and count.

Those statistics are calculated from the values displayed in the current context. They therefore depend on the date range, granularity, and aggregation method.

For example, a “Coffee” series aggregated with sum gives a total per period. A “Temperature” series aggregated with average shows a trend. If the result feels wrong, check the series aggregation method before editing measures.

Ranges and granularities

A range is the period you are looking at. A granularity defines how measures are grouped within that period.

For a day, DataJot works by hour. For a week, it can work by day or hour. For a month, it can work by day or week. For six months, it can work by week or month. For a year, it works by month.

The date context bar also lets you move to the previous period, next period, or presets such as today, last 7 days, last 30 days, or last 12 months.

Visualization configurations

A visualization configuration groups choices that influence display: visible statistics, reference lines, empty aggregate behavior, automatic scaling, threshold labels, Y-axis bounds, and thresholds.

It can be associated with several series. This is useful when several series should be read the same way. For example, several room temperature series can share the same thresholds and colors.

Some series created from a template can already be associated with a suitable visualization configuration.

Use thresholds

A threshold helps give meaning to a value. It combines an operator, a value, a color, and sometimes a label.

For example, you can decide that a temperature >= 25 means “Hot”. DataJot can then use that threshold color in some displays.

Threshold order matters. DataJot tests thresholds in order and uses the first one that matches. If two thresholds can apply to the same value, put the most important one first.

Stabilize the Y-axis

The Y-axis can be automatic or constrained by bounds.

A lower or upper bound is useful when you want to compare periods without the scale changing too much. For example, an indoor temperature chart can be easier to read when it stays within a stable range.