Altruistiq

Analyse your sustainability data in a familiar spreadsheet-like environment. Create tables, charts, and dashboards without exporting to Excel.

Analyse data

Learn what workbooks are in Analyse data, how they're organised into folders and pages, and the difference between exploring a workbook for personal analysis and editing it to publish changes.

What is a Workbook?

Learn how to navigate the Analyse data section. Find recently visited workbooks, browse folders across My Documents, shared workspaces, and AQ Workbooks, manage your favourites, and create new workbooks or…

Navigating Analyse data

Learn to navigate workbooks in Analyse Data. Covers the toolbar, editor panel, lineage view, add element toolbar, page tabs, and how to switch between viewing, exploring, and editing modes.

Navigating Workbooks

Understand View, Explore, and Edit modes in Analyse data workbooks. Learn what you can do in each mode, which permissions you need, and how the draft-and-publish workflow keeps your changes…

Workbook modes explained

Understand how workbooks, pages, and modes work. Learn to navigate the Analyse data interface and find what you need.

Getting started

Create and manage tables in Analyse data. Add columns from data models or build calculated columns with formulas. Create linked charts and pivot tables as child elements. Format tables with…

Create and manage tables

Learn how to filter data in tables and charts to focus on specific subsets. Covers filter types (list, date range, number range, Top N, text match), quick filtering, and converting…

Filter data in tables and charts

Sort table data by one or more columns and group rows into collapsible categories. Add summary calculations like totals and counts to groups. Includes guidance on optimising workbook performance.

Sort and group data in tables

Explore data at increasing levels of detail by drilling into charts. Use drill down controls to navigate predefined paths, interactive even for View only users, or drill on any column…

Drill down into data

Learn how to create and configure pivot tables to summarise your data by rows and columns. Covers building from data models or existing tables, changing calculations, formatting options, and managing…

Working with pivot tables

Create tables, apply filters, sort and group your data, and use pivot tables to summarise information across your sustainability programme.

Working with data

Learn how charts help you visualise patterns and trends in your sustainability data. Covers available chart types, chart components, how charts connect to data models, and creating charts from tables…

Introduction to charts

Reference guide to chart types in Analyse data. Covers bar, line, area, pie, scatter, KPI, gauge, waterfall, Sankey, and map charts. Includes guidance on choosing the right chart for your…

Chart types reference

Create charts to spot patterns and communicate insights. Covers chart types, customisation options, trend lines, and KPI displays.

Building visualisations

Learn what controls are and how they differ from filters. Controls are interactive elements that let viewers filter tables and charts without edit access—ideal for reports serving multiple audiences.

Introduction to control elements

Reference guide to all 13 control types in Analyse data. Covers selection controls, numeric inputs, sliders, date pickers, and drill down navigation. Use this to choose the right interactive filter…

Control types reference

Add interactive elements that let viewers filter and adjust workbooks without editing. Includes dropdowns, sliders, date pickers, and more.

Using controls

Learn to write formulas in Analyse data. Covers creating calculated columns, syntax for column references and operators, using autocomplete, troubleshooting errors, and handling empty values.

Formula basics

Look up formula functions by category. Covers aggregate, array, date, join, logical, maths, text, type, and window functions with descriptions and examples for building calculations in Analyse data.

Function reference by category

A guide for Excel users learning Analyse data formulas. Maps common functions (SUM, IF, VLOOKUP), explains key syntax differences, and provides ready-to-use recipes for sustainability data analysis.

Common formulas for Excel users

Write formulas to calculate new values from your data. Includes function reference and common formulas for Excel users.

Formulas and calculations

Set up conditional email alerts to monitor your sustainability data. Get notified when emissions exceed targets, new data arrives, or values fall outside expected ranges. Create and manage alerts from…

Set up alerts

Export pages, tables, and charts from Analyse data as PDF, PNG, Excel, CSV, or JSON. Download directly, send by email, or use export buttons. Includes permission levels, format guidance, and…

Download and export options

Schedule recurring exports

Share workbooks with colleagues, understand permission levels, and set up alerts to notify you when data meets specific conditions.

Collaboration and sharing

Your Dashboard

Find answers and get help from Intercom Support and Community Experts

This site employs cookies and other technologies that we and our third party vendors use to monitor and record personal information about you and your interactions with the site (including content viewed, cursor movements, screen recordings, and chat contents) for the purposes described in our Cookie Policy. By continuing to visit our site, you agree to our {websiteTermsLink}, {privacyPolicyLink} and {cookiePolicyLink}.

This site uses cookies and similar technologies ("cookies") as strictly necessary for site operation. We and our partners also would like to set additional cookies to enable site performance analytics, functionality, advertising and social media features. See our {cookiePolicyLink} for details. You can change your cookie preferences in our Cookie Settings.

We use cookies to make our site work and also for analytics and advertising purposes. You can enable or disable optional cookies as desired. See our {cookiePolicyLink} for more details.

Advertising cookies are set by our advertising partners to collect information about your use of the site, our communications, and other online services over time and with different browsers and devices. They use this information to show you ads online that they think will interest you and measure the ads' performance. Social media cookies are set by social media platforms to enable you to share content on those platforms, and are capable of tracking information about your activity across other online services for use as described in their privacy policies.

These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

These cookies are necessary for the website to function and cannot be switched off in our systems.

These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site.

You have the right to opt out of the sale of your personal information. See our {cookiePolicyLink} for more details about how we use your data.

Your Privacy Choices

We use cookies to enhance your experience. You can customize your cookie preferences below. See our {cookiePolicyLink} for more details.

Cookie Settings

Link, Press control-option-right-arrow to exit

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Thinking...

Searching through sources...

Analyzing...

Tickets submitted through the messenger or by a support agent in your conversation will appear here.