Skip to main content

 

Here are the different types of Blocks you can create in Pigment with some examples.

 

Object

Definition

Examples

Dimension List

A Dimension List is an axis used to analyze your data.

For example, you’re working in a spreadsheet and you say "I want to analyze my business volume by month, by country and by product type". 

The Dimensions Lists to create are MonthCountry, and Product Type.

Each item in this List is unique.

  • List of countries in which your company operates.

  • List of product categories.

  • List of employees.

Transactions List

A Transaction List is a list of items that may not necessarily be unique.

It usually represents a list of events or transactions that need be transformed or grouped for analysis.

  • List of orders.

  • List of accounting entries.

  • Human resource ledger.

Metric

A Metric is an indicator of what you want to measure.

It is used to store data according to a set of Dimensions.

Metrics can be entered manually, or can be calculated using formulas based on other Metrics, List Properties, or both.

  • Quantity sold

  • Revenue

  • Conversion rate

  • Commission Rate

  • EBITDA

  • FTEs

Table

A Table is a logical group of Metrics that can be analyzed and compared together.

It’s composed of one or more Metrics.

Metrics in a Table cannot have identical Dimensions, but they should share at least one common Dimension for clarity.

  • P&L

  • Cash Flow Statement

  • Balance Sheet

 

 

More information: 

Be the first to reply!