Bases Row Deltas shows each number in a Bases view next to its change from the prior row

See each number in a Bases group with the prior value and the difference.

MIT · no telemetry · core features free

North meter readings with current, prior and difference columns.
Open larger
version
1.0.2
released
downloads
8
review
Passed
health
Excellent
license
MIT
listed for
Desktop, Mobile
obsidian
1.13.4 or later

Linux, Windows, physical phones and tablets were not tested. A narrow desktop pane test checks scrolling and note navigation.

Directory facts fetched from community.obsidian.md/users/theluckystrike.

About Bases Row Deltas

You record readings, counts or balances in separate notes and want to see how each value changed from the one before.

Bases Row Deltas adds a view type to the core Bases plugin. You choose a number property, and the view shows the note link, the current value, the prior value and the difference. A comparison starts again at the start of each group.

You set the filters, the sort order, the groups and the limit in Bases. The plugin reads the rows that Bases supplies and adds the comparison columns.

Reading comparisons with separate groups, a number formula, and Pro optionsPlay demo

Free features

Select a number property

Choose Number property in the view options. A note property or an evaluated number formula can supply the value. A positive difference means the current value is greater than the prior value.

North meter readings with current, prior and difference columns.
Open larger

Keep the supplied groups and order

The view keeps the group order and the row order that Bases supplies, and each group starts a separate sequence. The plugin adds no sort of its own, so choose a sort that fits the data before you read a difference.

North and South groups with separate first rows.
Open larger

Leave invalid comparisons empty

A missing value keeps its row position, and the plugin does not skip it to find an older number. Text, boolean values and formula errors are invalid, even when the text looks like a number.

A missing reading that leaves two differences empty.
Open larger

Read new formula results

When Bases supplies updated results, the table reads the evaluated values again and replaces the old rows. The view does not calculate a formula itself.

A number formula with its own current and difference values.
Open larger

Show the comparison boundary

A note above the table says that comparisons use only the filtered and limited result set. The view cannot compare the first row with a note outside that set.

Two limited rows with the result-set notice visible.
Open larger

The free version compares one number property with the prior row, with no second property, no row offset and no change per day.

Pro features

Pro costs $5 a month or $15 one time through GitHub Sponsors. One sponsorship turns on Pro in every plugin that has it.

Compare several properties Pro

Select a second and a third number property to compare up to three properties in one table. Each property has its own current, prior and difference columns.

Reading and cost values compared side by side.
Open larger

Choose an earlier row Pro

Set Prior-row offset from 2 to 100 to compare with a row farther back. Missing rows still count toward the offset, and the offset stays inside each group.

Offset two compares the third reading with the first.
Open larger

Show change per day Pro

Select a date property to add a Per day column with the difference divided by the days between the two dates. The date must be a Bases date value, because a text property is not converted.

Changes divided by two-day intervals.
Open larger

Set up Bases Row Deltas

needs

  • Obsidian 1.13.4 or later
  • The core plugin Bases, turned on

steps

  1. Open a base and add a view of type Row deltas from the view menu.

  2. Open the view options and select a number property.

  3. Set the sort in Bases, for example an ascending sequence number.

  4. Add a grouping when notes from different meters or projects need separate comparisons.

If the app can't find a new plugin yet, try again later. Obsidian says a plugin that passes the review shows in the app within 24 hours.

Need a change for your team? I build custom Obsidian plugins and features.

Questions about Bases Row Deltas

Does the view change my notes?

No. The comparison code reads Bases values and opens note links, and it writes no differences to properties. Bases can save changes to the view options in the base file.

Why is a difference empty?

A difference is empty when the current or the prior value is missing or invalid. The first row of each group has no prior row, so its difference is empty too.

Can it compare with a note outside the filter?

No. Comparisons use only the filtered and limited result set that Bases supplies. Widen the filter or the limit in Bases to include more rows.

Why do I see a long decimal fraction?

The view shows the numeric string value of each result, so decimal arithmetic can produce a long fraction. The plugin has no precision setting.

Network use

Until you select Sign in with GitHub, Bases Row Deltas makes no network requests. Sign in and the sponsorship check contact github.com and api.github.com with the scope read:user, and a successful check is reused for 7 days. The plugin sends no note content, file names or other vault data.

Read the full network disclosure

Questions or ideas?

Tell me what is broken in Bases Row Deltas, or what it should do next.

Send feedback

Bases Row Deltas 1.0.2, MIT license

MIT · no telemetry · core features free