Awesome

:gift_heart: Sponsor this project on Github or :coffee: Get me a coffee if you like this plugin!

Overview

Render tables with basic math functions using data from your blocks. Just use the slash command /Render table to get started!

Instructions

In the examples below, the {{renderer ...}} is automatically generated when you type /Render table, so you just need to add the portion from rows onwards.

To add the mathematical formulas, add it to the same block as rows. Fr example, sum-2 sums up the values in column 2 of the table.

• {{renderer :tables_656a0198-9b78-4d81-ae9a-09811cce3c8d}}
  • rows sum-2
    • hello
      • hello
    • stuff
      • stuff
    • [[John Tan]]
      • The quick brown fox jumps over the lazy dog

Basic table

To draw a table above, you can use any one of the below approaches, with the flags data, rows or cols.

1. data

- {{renderer :tables_656a0198-9b78-4d81-ae9a-09811cce3c8d}}
  - data
    - Category
      - Fruits
      - Vegetables
      - Fruits and Vegetables
    - Fresh Produce
      - Apples
      - Lettuce
      - Tomatoes
    - Price
      - 1
      - 3
      - 5

2. rows

- {{renderer :tables_656a0198-9b78-4d81-ae9a-09811cce3c8d}}
  - rows
    - Category
      - Fresh Produce
        - Price
    - Fruits
      - Apples
        - 1
    - Vegetables
      - Lettuce
        - 3
    - Fruits and Vegetables
      - Tomatoes
        - 5

3. cols

- {{renderer :tables_656a0198-9b78-4d81-ae9a-09811cce3c8d}}
  - cols
    - Category
      - Fresh Produce
      - Price
    - Fruits
      - Apples
      - 1
    - Vegetables
      - Lettuce
      - 3
    - Fruits and Vegetables
      - Tomatoes'
      - 5

Table with basic stats

The following basic statistical calculations are available:

• Sum (sum)
• Average (average)
• Median (median)
• Mode (mode)
• Variance (variance)
• Standard Deviation (sd)
• Sample Standard Deviation (ssd)
• Percentile (percentile)*

To use any of the above, use its shortcut (in brackets above) with the columns that you would like to compute (<shortcut>-<column>).

Example

1. sum-3 average-3 median-3 mode-3 will render:

2. *Percentile requires an additional flag to indicate the perecntile that you would like to compute. percentile-3-50 will compute the 50th percentile of the 3rd column.

Installation

Look for logseq-tablerender-plugin in the marketplace and install from there.

Credits

stats-lite for providing the calculations.