Billy

Less Documentation

Introduction to Less. Find insights in five minutes.

Introduction

Connections

Models

Inviting Team Members

Get email alerts when connections and models fail

Notifications

Monitor your connections and models with logs

Logs

Versions

Less IP

Run connection and models in a specific the order

Orchestration

PowerBI

Tableau

Metabase

Steep

Input

Output

Select, order, rename and change format of your columns

Change Columns

Create Rows

Dynamic Rename

Fill

Filter

Formats

Reduce the number of rows in your data set

Limit

Multi Row

Pick

Rename

Replace text values in one or multiple columns

Replace

Sort

Transform

Unique

Add a number of days to a date while accounting for holidays

Add Business Days

Calculate

Compare

Calculate Person and Spearman correlations between two columns

Correlation

Add the number of days to two dates while accounting for holidays

Count Business Days

Cumulative

Calculate the difference between date columns in seconds, days, months, etc.

Date Difference

Extract part of date columns to new formats

Date Format

Add or subtract days, seconds, hours and more from date columns

Date Math

Calculate the numerical difference between rows

Difference

IF Column

Parse JSON

Regex

Row ID

Running Interval

Split Columns

Turn weird date formats into date/datetime formats

String to Date

Text Column

Separate data in groups and perform calculations within those groups

Group By

Pivot

Transpose

Append

Combine

Stack

Comment

Manual Input

Get GeoJSON Point and Latitude/Longitude from geographic data

MapBox - GeoCoding

Get Distance, Duration and LineString between Two Points

MapBox - Directions

MapBox - Polygon

Test if a point is inside an area/polygon

Point-in-Polygon

Output to Tableau

Today

Row Warning

Use Connectors to get your data into Less

Quickstart

Three Types of Connectors

24SevenOffice

ActiveCampaign

ActiveCampaign - Custom Objects

Airtable

Amazon Ads Reports

Amazon Seller Central

Asana - All Projects

Asana - Single Project

AWS Billing

Azure Files

BigQuery

Bing Ads

Your objective determines how you should build in Less

Clearhaus

Clickhouse

Clickhouse - Query

Customer.io

CVR Register (DK)

DAWA (DK)

Demo Data

Dinero

DMI (DK)

Dynamics365

e-conomic

e-conomics - Basic

ECB Exchange Rates

Excel

Product Exercise

Finance Exercise

Marketing Exercise

MySQL

MySQL - Query

PostgreSQL

PostgreSQL - Query

Learning Less

Consolidating and creating metrics with data from three sources

Exercise: Marketing

Exercise: Sentiment Score

Execute Connection

Connection Task Status

Model

Execute Model

Model Task Status

Tools

Connectors

Academy

API Reference

Back to Website

Support

Credentials

Whitelisting

Functionality

Tips and Debugging

Permissions restrict users from accessing assets or performing certain actions

An ability enables you to do something on Less

Abilities

Roles

Groups

This exercise will show you how to work with financial data to generate Income Statements, create metrics and adjust to accrual-based account.

Part One: Profit & Loss

Part Two: Metrics

Part Three: Revenue Recognition