How to use Tabidoo for calculating margins, and creating number lines displaying data with a speedometer?

Introduction to Tabidoo

Tabidoo is a powerful tool for managing and analyzing business data, enabling users without deep technical knowledge to efficiently handle information. This guide will walk you through the steps of creating number lines for product IDs, calculating margins, and creating visually appealing dashboards in Tabidoo.

Step 1: Creating Product IDs in Tabidoo

1. Setting Up Tables: In Tabidoo, set up two tables - 'Materials' and 'Products'. The 'Materials' table will contain information about material costs, while 'Products' will serve to track your products.

2. Adding a 'Number Line' Field: In the 'Products' table, add a 'Number Line' field. Set this field to automatically generate sequential numbers for each new product.

3. Formulating Product ID: Create a formula that combines the number line with additional data, such as the year of production, to give each product a unique ID.

Step 2: Calculating Margins

1. Determining Costs and Selling Price: In the 'Products' table, record the labor and material costs and the selling price of each product.

2. Margin Calculation: Create a formula that calculates the margin as a percentage of the selling price. The margin is calculated by subtracting the total costs from the selling price, dividing this difference by the selling price, and multiplying the result by 100.

3. Rounding for Clarity: To make the results easily readable, round the resulting margin percentage to two decimal places.

Step 3: Creating Dashboards

1. Using Speedometer Dashboards: In Tabidoo, create a dashboard in the style of a speedometer that visually displays the margins of your products.

2. Setting Metrics and Colors: Set different performance levels (e.g., green for high margin, red for low) and assign corresponding colors for easy navigation.