How to build and connect charts to data

Building Projects and Dashboards: Learn how you can connect your data to charts and map columns.

How to Connect Your Data to Charts and Map Columns

In this guide, we'll walk you through the process of connecting your data to charts and mapping columns for visualization.

You can connect various data sources, such as Peaka Tables, Peaka Queries, or SaaS connectors, to create meaningful charts. If you're unsure about how to connect your data sources, please refer to the following articles:

For this example, we'll use a Peaka Table named "Revenue." Here are the details of the table:

peaka table data

Connecting Data to Charts

All chart components in Peaka connect to data in a similar way. We'll demonstrate this process using an Area Chart component as an example.

  1. Select a data source: In your Area Chart component, locate the Data Source input. Clicking on this input will display available data sources, including Peaka Tables, Peaka Queries, and SaaS Connectors (if you've set them up).

  2. Choose your data: Click on the data source you want to use, and it will populate the chart with that data.

selecting data for combined chart

Mapping Columns for Visualization

To customize your chart and map specific columns for the x or y-axis, follow these steps:

  1. Open column mapping: In the Area Chart component or similar chart types, look for the Open Column Mapping button.

  2. Column mapping modal: Clicking on this button opens a modal where you can map columns to different chart attributes. The first field in the modal typically represents the value of either the x or y-axis, depending on the chart type. The columns listed below the first field are the data points shown in the chart.

    • Adjust the value of the x or y-axis as needed to tailor your chart.
    • Add or remove columns to control what data is displayed on the chart.
editing combined chart

By following these steps, you can connect your data to charts and precisely map columns to create insightful visualizations in Peaka.