1. What is Tangrid?

Tangrid is a generic data recording and analysis tool. It can be used for various purposes such as accounting, journaling, time tracking, leave/work hours, exam scores, health data, and more.

Tangrid is a new species that sits between Excel spreadsheets and specialized applications. It is easier to use than spreadsheets and more flexible and free than specialized applications, and has a wide range of capabilities.

2. Three basic steps for usage

Create template → Add records → Configure charts

https://www.youtube.com/watch?v=r85MYWVYszI

3. Template

Template are composed of multiple properties. There are 13 types of properties: Group, Number, Progress, Rating, Time, Duration, Time Range, Checkbox, Select, Multi-Select, Text, Image, and Formula. Template can be thought of as table, with properties representing columns. Creating a template is like setting up a table, and each added record is a row in the table.

There are four ways to create a template:

  1. Create a template directly.
  2. Download a template from the template library.
  3. Connect to Notion Database: Before connecting, authorization to access Notion is required. Then, you can connect to an existing Notion Database or create a new one.
  4. Import from a CSV file: During import, you can choose a column as the creation time and select the appropriate time parsing format. If no creation time is specified, the current time will be used as the creation time. The default property type for imports is "Text," and you need to manually convert them to the appropriate property types.

When to use Group property:

  1. Group composed of multiple sub-properties of the same type, allowing you to group related data for calculations and analysis. All sub-properties can be analyzed using a single chart.
  2. For example, it is recommended to use a Group for expense tracking template of multiple categories, but not for Running template with distance and speed properties, as distance and speed are two different types of data and are not typically subject to addition or subtraction calculations.

4. Chart Configuration

  1. A template can be configured with multiple charts, allowing you to perform statistical analysis from different perspectives.
  2. There are currently 7 types of charts (Bar Chart, Line Chart, Pie Chart, Heatmap, Calendar, Scatter Chart, Range Chart) and two types of numerical statistics (Formula, Summary).
  3. If the result of a formula or Summary calculation is a number, it can also be represented as a progress bar, rating bar, duration, etc.