Presight
  • 👋INTRODUCTION
    • What is Presight?
    • Core Concepts
      • Metrics
      • Events
      • Segments
        • Source Columns
        • Custom Segments
    • The Presight Workspace
      • Workspace Overview
      • The Data Docs
      • Data Library (Datahub)
  • ➡️DATA IN
    • Connect
      • Data Warehouse
      • Data Connectors
        • API Connector
        • Google Sheets Connection
        • CSV Import
        • Dimensional Dates (Dimdates table)
        • QuickBooks Online
        • HubSpot Connector
    • Sync
    • Tables & Columns
      • Browse & Edit
      • Primary Key
    • Governance
  • ⚙️MODEL
    • Data Relationships
      • Table Relationships
      • Hierarchy
    • Metrics
      • Create Metrics
      • Ownership & Permission
      • Deletion
    • Events
      • Creating Events
    • Custom Tables
      • Table Builder
        • Filter a Dataset
        • Simple Data Enrichment
        • Advanced Enrichment - Segmentation
      • Custom SQL Query
    • Segments & Custom Segments
      • Dimensions from Data Sources
      • Create a New Dimension
    • Formulas
      • Metric Formulas
      • Data Transformation Formulas
  • 📊ANALYSIS
    • The Data Docs
      • Explorations
        • Docs Widgets
      • Reports
      • Dashboards
      • Layout & Beautify
      • Organize
      • Collaboration
    • Data Widgets
      • Charts
        • Query Syntax
        • Data in a Chart
        • Interacting with a Chart
          • Breakdown
          • Chart Filter
          • Time Change
          • Chart Menu
          • View Constituent Records
          • Version views in Chart
        • Chart Configuration
      • Metric Table
        • Creating a Table
        • Interact with a Table
          • Adding Metrics
          • Adding Sections and Organizing metric list
          • Table Filter
          • Table Summaries
          • Quick Chart Creation from Table
          • Timeline Navigation
        • Table Menu
        • Table Breakdown
        • Breakdown Options
        • Interact with Table Metrics
        • [Advanced] Automatic Variance Calculation
      • Records Table
        • Accessing Data Records on-demand
    • Breakdowns & Filters
      • [Advanced] Dimension Path
    • Event Analytics
      • Event Funnel
      • Cohort
      • Event Path
    • Segmentations
      • Metric Segments
      • Filtered Segments
    • Ask AI (Beta)
      • Ask Presight
      • Presight AI in your Chat Tools
  • 📈PLANNING
    • Creating Versions
    • Interacting with Versions
    • Interacting with Future Data
    • Forecasting a Metric
  • 🏛️GOVERNANCE
    • Overview
    • Table Restriction
    • Metric Permission & Sharing
    • Doc Sharing
  • ⬇️DATA OUT
    • Export Data
Powered by GitBook
On this page
  • 1. KPI (Key Performance Indicator)
  • 2. Line Chart
  • 3. Bar Chart
  • 4. Horizontal Bar Chart
  • 5. Donut Chart
  • 6. Area Chart
  • 7. Combo Chart
  • 8. Metric Funnel Chart
  • 9. Scatter Plot
  • 10. Treemap
  • 11. Bubble Chart
  • 12. Heatmap
  • 13. Waterfall Chart
  • 14. Event Funnel
  • 15. Cohort Chart
  • 16. Sankey Chart
  1. ANALYSIS
  2. Data Widgets

Charts

PreviousData WidgetsNextQuery Syntax

Last updated 5 months ago

Presight supports a wide variety of chart types designed to help you tell compelling stories with your data, uncover insights, and make smarter business decisions. Here's an overview of the chart types, their purpose in a business context, common use cases, and the setup requirements.


1. KPI (Key Performance Indicator)

  • Purpose: To highlight critical numbers that reflect your business performance at a glance. Think of it as your dashboard's headline metric.

  • Example Use Case: Showing total revenue, daily active users, or customer churn rate.

  • Setup Requirements:

    • Metrics: Exactly 1.

    • Breakdowns: Multiple, optional, typically None.

    • Time Context: Not needed.


2. Line Chart

  • Purpose: Ideal for showing trends over time and tracking changes. It’s great for spotting growth patterns or seasonal fluctuations.

  • Example Use Case: Monitoring monthly sales trends or website traffic over a year.

  • Setup Requirements:

    • Metrics: At least 1.

    • Breakdowns: Multiple, optional, typically 1.

    • Time Context: Recommended.


3. Bar Chart

  • Purpose: Perfect for comparing performance across different categories, like regions or product lines. It helps you quickly identify which areas are doing well and which need attention.

  • Example Use Case: Comparing revenue by region or sales by product category.

  • Setup Requirements:

    • Metrics: At least 1.

    • Breakdowns: Optional, multiple.

    • Time Context: Recommended.


4. Horizontal Bar Chart

  • Purpose: Similar to a bar chart but with horizontal orientation, making it easier to read when dealing with long category names or a lot of data points.

  • Example Use Case: Ranking products by sales volume or sorting departments by profitability.

  • Setup Requirements:

    • Metrics: At least 1.

    • Breakdowns: 1.

    • Time Context: Recommended.


5. Donut Chart

  • Purpose: Great for showing how a whole is divided among its parts. It answers questions like, "What portion of our revenue comes from Product A?"

  • Example Use Case: Displaying the share of sales by product category.

  • Setup Requirements:

    • Metrics: Exactly 1.

    • Breakdowns: Typically 1.

    • Time Context: Not Required.


6. Area Chart

  • Purpose: A visually engaging way to show how values build over time, making it perfect for cumulative data trends.

  • Example Use Case: Tracking the total growth in revenue or customer acquisition over a year.

  • Setup Requirements:

    • Metrics: At least 1.

    • Breakdowns: Multiple, Optional.

    • Time Context: Recommended.


7. Combo Chart

  • Purpose: A versatile chart for comparing multiple data points using different chart types, like bars and lines together.

  • Example Use Case: Comparing monthly revenue (bars) against profit margin trends (line).

  • Setup Requirements:

    • Metrics: At least 2.

    • Breakdowns: Multiple, Optional, per Metric is supported.

    • Time Context: Recommended.


8. Metric Funnel Chart

  • Purpose: Unlike the Event Funnel, which tracks individual user journeys, the Metric Funnel visualizes the aggregated total of metrics for each stage in a process. It’s a great tool for comparing the relative sizes of different stages.

  • Example Use Case: Comparing total revenue, costs, and net profit as steps in a financial process.

  • Setup Requirements:

    • Metrics: At least 2.

    • Breakdowns: Optional, Multiple.


9. Scatter Plot

  • Purpose: Perfect for understanding the relationship between two factors. It helps answer questions like, "Does spending more on ads lead to higher revenue?"

  • Example Use Case: Comparing advertising spend against revenue or analyzing employee performance.

  • Setup Requirements:

    • Metrics: Exactly 2.

    • Breakdowns: Multiple, Optional.

    • Time Context: Not Required.


10. Treemap

  • Purpose: A powerful way to showcase proportions within a hierarchy. It answers, "Which products or regions contribute the most to sales?"

  • Example Use Case: Visualizing revenue by product category and subcategory.

  • Setup Requirements:

    • Metrics: Exactly 1.

    • Breakdowns: At least 1.

    • Time Context: Not Required.


11. Bubble Chart

  • Purpose: A fun and creative way to compare data points with size, position, and color to show relationships or impact. It’s great for storytelling.

  • Example Use Case: Displaying market size (bubble size) by region and profitability (X and Y axes).

  • Setup Requirements:

    • Metrics: Exactly 3 (X, Y and Size)

    • Breakdowns: Optional, Multiple, Color Coded using Legend is supported.

    • Time Context: Not Required.


12. Heatmap

  • Purpose: Use this to find patterns, correlations, or hotspots in your data, represented by varying shades of color.

  • Example Use Case: Analyzing sales performance across regions and sales teams.

  • Setup Requirements:

    • Metrics: Exactly 1.

    • Breakdowns: At least 2.

    • Time Context: Not Required.


13. Waterfall Chart

  • Purpose: Best for explaining the story behind changes in a value, like how various factors contribute to profits.

  • Example Use Case: Breaking down profit growth by cost reductions and increased revenue.

  • Setup Requirements:

    • Metrics: Exactly 1.

    • Breakdowns: Optional 1.

    • Time Context: Recommended


14. Event Funnel

  • Purpose: Tracks and visualizes the step-by-step journey of individual users as they progress through a sequence of events. This chart is excellent for understanding user behavior, identifying drop-off points, and improving conversion rates.

  • Example Use Case: Tracking a customer’s journey from visiting a website to making a purchase or completing onboarding steps.

  • Setup Requirements:

    • Events: More than 1.

    • Metrics: Optional.

    • Breakdowns: Multiple, Optional, Typically 1

    • Time Context: Recommended.


15. Cohort Chart

  • Purpose: A great tool for analyzing customer behavior over time. It answers questions like, "How many customers return after their first purchase?"

  • Example Use Case: Evaluating customer retention rates by cohort (e.g., sign-up month).

  • Setup Requirements:

    • Events: Exactly 2 (1 cohort and 1 returning)

    • Metrics: Optional.

    • Breakdowns: Multiple, Optional.

    • Time Context: Recommended.


16. Sankey Chart

  • Purpose: Perfect for illustrating flows or connections between different stages or categories. It’s great for seeing how things are distributed or moved.

  • Example Use Case: Visualizing user journeys through a website or tracking supply chain flows.

  • Setup Requirements:

    • Events: Exactly 1.

    • Metrics: Optional (flow-based visualization).

    • Breakdowns: Not Supported.

    • Time Context: Recommended.

📊