Type: Analytics
CSS Enabled: ✅
Notable Settings
Spreadsheet
Select the spreadsheet to display in your Block.
Chart Type
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.
Setup
Label Field
Select the spreadsheet column you want to use for the visual label for each segment in your chart.
Value Field
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.
Group By (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.
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.
Visibility
Use these settings to enable or disable visibility of the block depending on the user group or the condition / set of conditions you've configured.
Permissions
Set permissions for your users using conditions to determine who can create, delete or edit records on this block.
Save as Custom Block
Click to save the configuration of your block and re-use it anywhere else you'd like in your app.