LogoLogo
ProductsPricingGlossary Launch Acho
  • 🎉Welcome
  • Introduction
  • What is Acho?
  • How does Acho work?
    • Proof of Concept (PoC)
  • App Builder
    • Get Started
    • Core Concepts
    • Overview
    • App construction
      • App Configuration
      • Pages
      • Interactions
        • Add an interaction
        • Add conditions to interactions
        • Event payload
        • Ordering interactions with action flow
        • Transformer
        • Actions
          • Navigation
          • Element
          • Data Source
          • App
          • Page
          • API Service
          • Database
          • Media Service
      • Table
      • Metric
      • Query
      • Data Store
      • Elements
        • Table & Chart
          • Searchable Table
          • Table
          • Chart
          • Score Card
        • Form Elements
          • Form
          • Search Bar
          • Checkbox
          • Date Picker
          • Custom Form
          • Input
          • Multiselect
          • Radio Button
          • Radio List
          • Rich Text Editor
          • Select
          • Switch
          • Textarea
          • Upload
        • Web Elements
          • Badge
          • Button
          • Clickable
          • Collapse Menu
          • Divider
          • Icon
          • Image
          • Link
          • Message
          • Modal
          • Notification
          • Pagination
          • Popover
          • Rate
          • Rich Text
          • Tabs
          • Text
        • Layout Elements
          • Container
          • List
        • Advanced elements
          • Code Block
          • Condition
          • Print
        • CSS Styles
          • General techniques
          • Layout
          • Spacing
          • Size
          • Position
          • Typography
          • Background
          • Border
          • Effect
        • Form Check
        • Tooltip
      • Accessors
      • Plugin Store
    • Popular Use Cases
      • Build a chart from Table Nodes
      • Create a table
      • Create a list
      • Create a filter
      • Create a search bar
      • Use Custom Form Container to collect user inputs
      • Drill down on a table
      • Download file from query node
      • Set loading animations
      • Modify a database
      • Navigate to a different page
      • Set up dynamic routing
      • Update app data using accessors
      • Create a Chart with Code Block and D3 Library
      • Rich text and rich text editor
      • Send an Email via Mailjet Plugin
    • Preview
    • Publish
      • Embed published app on website
    • Version Control
    • App User Management
      • Onboarding Page
      • Sign in page
      • Guest Isolation and Private Session
    • Theme
    • FAQ
  • Acho Studio
    • Quick Start
    • Resources
      • Add a resource
      • Supported data sources
        • Airtable
        • Amazon Ads
        • Amplitude
        • Amazon Seller Partner
        • Apify Dataset
        • Appstore
        • Asana
        • API Connector
        • API Template
        • AWS CloudTrail
        • Azure Table Storage
        • Batch Files
        • Bamboo HR
        • BigCommerce
        • BigQuery
        • Bing Ads
        • Braintree
        • Cart.com
        • Chargebee
        • Chargify
        • Chartmogul
        • Clickhouse
        • Close.com
        • CockroachDB
        • Confluence
        • Customer.io
        • Delighted
        • Dixa
        • Drift
        • Facebook Marketing
        • Freshdesk
        • Freshsales
        • Freshservice
        • GitHub
        • GitLab
        • Google Ads
        • Google Analytics
        • Google Sheets
        • Google Search Console
        • Greenhouse
        • Harness
        • Harvest
        • HubSpot
        • IBM Db2
        • Instagram
        • Intercom
        • Iterable
        • Jenkins
        • Jira
        • Kafka
        • Klaviyo
        • Kustomer
        • Lemlist
        • Lever Hiring
        • LinkedIn Ads
        • Linnworks
        • Mailchimp
        • Marketo
        • Microsoft Teams
        • Mixpanel
        • Monday
        • MongoDB
        • MySQL
        • My Hours
        • NetSuite
        • Notion
        • Okta
        • OneDrive
        • OneSignal
        • Oracle DB
        • Outreach
        • PagerDuty
        • Paypal Transaction
        • Paystack
        • Pipedrive
        • PersistIq
        • Pinterest
        • Plaid
        • PostgreSQL
        • PostHog
        • PrestaShop
        • Qualaroo
        • QuickBooks
        • Recharge
        • Recurly
        • Remote File
        • S3
        • Salesforce
        • Salesloft
        • SearchMetrics
        • Sendgrid
        • Sentry
        • Short.io
        • Shopify
        • Single File
        • Slack
        • Smartsheets
        • Snapchat Marketing
        • Snowflake
        • SQL Server
        • Square
        • Stripe
        • SurveyMonkey
        • Tempo
        • TikTok Marketing
        • Trello
        • Twilio
        • Typeform
        • VictorOps
        • WooCommerce
        • YouTube Analytics
        • Zendesk Chat
        • Zendesk Sunshine
        • Zendesk Talk
        • Zendesk Support
        • Zenloop
        • Zoho CRM
        • Zoom
        • Zuora
    • Data Prep (Projects)
      • Create a Data Prep Project
        • Create a table tab
        • Copy a table tab
        • Hide a table tab
      • Apply an action
        • View
          • Hide Columns
          • Filter
          • Sort
          • Cut
          • Rename
          • Move Column
        • Combine Tables
          • Join
          • Union
        • Transformation
          • Pivot Table
          • Unpivot
        • Data Cleaning
          • Cleanse
          • Replace
          • Change Type
          • Deduplicate
          • Split
          • Flatten
        • Tools
          • Formula
          • SQL Editor
            • SQL Editor Queries
            • All functions in Formula/SQL
              • Mathematical Functions
              • String Functions
              • Date Functions
              • Datetime Functions
              • Time Functions
              • Timestamp Functions
              • Conditional Functions
              • Type Conversion
              • Other Functions
        • Reserved Keywords
      • Pipeline
      • Edit your pipelines
      • Generate column summary for inspection
      • Use URL to access and share your project
      • Write a description for your project
      • Delete a resources/project/tab
    • Data Flow
      • Export data
        • Download CSV files
        • Excel Connector
        • Google Sheets Connector
        • Embed a table on your website
          • Data Usage Agreement
        • Apache Superset
        • Chartio
        • Looker
        • Metabase
        • Power BI
        • Qlik
        • Tableau
        • MongoDB
        • MySQL
        • MSSQL
        • Snowflake
        • PostgreSQL
        • BigQuery
    • Set up Data Sync
    • FAQ
  • Organization
    • Get started
    • Create an organization
    • Invite people to your organization
    • Share your resources
    • Share your projects
    • Share your apps
    • Change payment method on file
  • FAQ
    • I can't find data after uploading a big CSV file
Powered by GitBook
On this page
  • Create A Metric
  • Generate by AI
  • Layer
  • SQL
  • Interactions
  • Use cases for Tables

Was this helpful?

  1. App Builder
  2. App construction

Metric

PreviousTableNextQuery

Last updated 1 year ago

Was this helpful?

Metrics are derived from Table to represent calculated or aggregated fields and columns. Metrics can be an aggregated table, a series of meters or even a single value of meter.

Metrics work as a data source that's ready for reporting and charting. All pages across the app can access metrics data.

Create A Metric

Metrics are always created from Tables. To create a metric in an app, select Data Source -> Table -> Create a Metric or select Data Source -> Metric -> Create Metric -> Select a Table source.

There's three ways to create Metrics:

  1. Generate by AI: Type natural language to generate metrics with AI

  2. Layer: No code GUI to perform summarize, filter, sort and limit to the resource

  3. SQL: Write SQL code that program the metrics logic

Generate by AI

The first and default way to create metrics is Generate By AI. In the metrics pane, you can describe what metrics you want using natural language prompt. Our AI metrics will generate the metrics according to your description and table schema. There are also five suggested prompt suggested to use.

Iterate metric result

Occasionally, the initial metric may not align perfectly with your expectations. In such instances, you have the opportunity to reiterate metric by sharing additional information and your creative insights, allowing AI to modify the metric to your precise requirements. Simply type your requests within the same conversation. Our AI retains knowledge of previous conversations and metric results.

If you are still not satisfied with the result, you can switch to SQL mode and edit the SQL query yourself.

Clear conversation

If you want to start over, you can click Clear conversation. Our AI will then forget the current conversation and begin anew with your new prompt and the original table schema.

Layer

Layer is a remarkable no-code tool that empowers you to weave logic into your original table within several clicks.

It offers support for several fundamental operations:

  1. Summarize: This operation allows you to extract meaningful insights and summaries from your data.

  2. Filter: With the Filter function, you can easily narrow down your data to focus on specific criteria or conditions.

  3. Sort: Use the Sort feature to arrange your data in a structured and organized manner.

  4. Limit: The Limit option lets you restrict your data to a specified range or quantity.

You have the flexibility to combine these operations in various ways, allowing you to adapt your data processing within the app builder to suit your specific requirements.

SQL

You can use the query generated by AI and further edit it in SQL mode, granting you unlimited flexibility. However, if you are a deep SQL expert, Query is designed for you to craft templated queries.

Interactions

The interactions of metrics are completely inherited from the Table

Actions

  • Get Metric Data

    Retrieve table node data with certain page, search and order.

    • Page Size: The number of results to display per page. A higher page size will show more results on a single page, while a lower value will show fewer.

    • Page Number: The specific page (starting from 1) of results to display based on the defined Page Size. For example, if there are 400 rows and the Page Size is set to 100, selecting Page Number 3 will show results 201-300.

    • Search Fields: Specifies the database columns or attributes that should be searched. This helps in narrowing down the search to specific fields rather than searching across all columns.

    • Search Value: The actual text or value to search for within the chosen Search Fields. The database will return results that match or contain this value in the specified fields.

    • Sorting Field: Determines the database column or attribute by which the results should be sorted. For example, if you choose a 'Date' field, the results will be sorted based on dates.

    • Sorting Order: Determines the direction of the sort for the selected Sorting Field. Common values include 'Ascending' (A-Z, smallest to largest, or oldest to newest) and 'Descending' (Z-A, largest to smallest, or newest to oldest).

Events

  • Data Update: Triggered when the data node runs.

  • Data Update Error: Triggered when errors occur as the data node runs.

Use cases for Tables

The metric offers an original table preview before before you enter the prompt. You can also check the original table by clicking the eye iconat the top at any time. After entering the prompt, it typically takes 5 to 30 seconds for the AI to generate the metrics. Then, the metric results will populate and replace the table preview at the bottom of the metric pane.

Tables
Charts
Score Card
Query Nodes
Accessors
Two ways to create a metric