Chart Block
Patrick avatar
Written by Patrick
Updated over a week ago

Basics

Label

A simple visual label that displays at the top of your Block container. Also used for your internal reference in the page builder.

Spreadsheet

Select the spreadsheet to display in your Block.

Chart Style

Change the type of chart with options including Bar, Doughnut, Line, Pie, and PolarArea. Different types of data tend to work better with different Chart Styles, so we suggest experimenting to see what works.

Chart Label

Select the spreadsheet column you want to use for the visual label for each segment in your chart.

Chart Value

The numeric value to use in your chart. This setting determines what value is actually used in your chart, and it must be a numeric value or it will not work and no values will display.

Grouping Column (optional)

By default, the Chart displays all rows in your spreadsheet as separate chart segments, such as bars in the Bar chart. Often, you will actually want to display a 'summary' of data, and this is most often done by grouping the data by some field.

For example, you might have a list of projects with a 'status' field. Instead of displaying every project in the chart as it's own segment, you select the 'status' field as your 'Grouping Column', which converts your data into a smaller number of segments grouped by 'status', with Grouping Metric multiple options for the display values.

Grouping Metric (optional, dependent on Grouping Column)

If you've selected a Grouping Column, the Grouping Metric setting allows you to determine which calculation to apply to the grouped values, from the following options:

Sum - Total of the 'Chart Value' field for the items in each group.

Average - The average of the 'Chart Value' field for the items in each group.

Count - The number of items in each group.

Percent - The percentage of the summed 'Chart Value' field for the items in each group.

Layout Position

If you've selected a Layout for your page, you will see the Layout Position select dropdown. This setting determines which 'slot' in your Layout the current Block is located in. As you change the Layout Position, you'll see your block move around into different Layout slots.

Alternatively, you can add a new block to a specific layout slot by clicking on the slot directly.

Styles

Color Scheme

Select a color scheme for your chart.

Show Values

Always display the numeric values of your chart without needing to hover or select specific segments.

Filters

Visible Filters

Give users the ability to filter the data in your Table with select dropdowns and other input fields.

Hidden Filters

If you need to limit the data a user can see in your app based on who is logged in, you can create a Hidden Filter using custom user fields.

With this simple feature, you can build a dynamic application that shows different data to different users, while keeping all data in a single sheet.

Example: Your company has three distinct teams accessing the same page, but you want them to only view the records that relate to their team.

Did this answer your question?