Tape has four chart types: Pie chart, Donut chart, Bar chart, and Line chart. All of them group your records, then calculate a value for each group.
Note: Reports and charts are only available on the Premium Plan. Learn more about plans →
Add a chart
Unlock the dashboard app (learn how →) and type
/.Under
Reports, select a chart type.Under
Select a database, choose the database. To change the settings, hover over the chart, click•••at its top right, and selectEdit report.Set
Group by, and choose aFieldandCalculationif you want more than a count.
Which chart to use
Pie chartandDonut chart: share of each group in the whole. A donut chart can show the total in the middle.Bar chart: compare groups with each other, or split each group into subgroups.Line chart: follow values over time, usually grouped by a date field.
Group and subgroup
Group bycreates the groups. Learn more about grouping →Subgroup bysplits each group again, for example deals per month, split by owner. It's available forBar chartandLine chart. It isn't offered whenGroup othersis on, or when the calculation isAverage,Median,Minimum, orMaximum.Sort,Group limit,Group others,Hide empty groups, andInclude empty recordswork as they do in the list report.Group othersisn't available for line charts.
Bar chart options
Orientation:VerticalorHorizontal.Bars: appears when you useSubgroup by. ChooseStacked,Grouped, orStacked 100%.
Line chart options
Smooth lines: rounds the line between points.Start values from zeroandStart groups from zero: control where the axes begin.
Axes
For bar and line charts:
Hide axes: hides both axes.Show axes title: shows a title field for each axis. Select it and enter text, or leaveAdd title.Show grid lines: shows lines behind the chart.
Colors, labels, and legend
Color: chooseMulticolored(LightorDark) orUnicoloredwith one color. When you group (or subgroup) by a select orStatusfield,Multicoloredalso offersOptions, which uses the colors of the field's options.Label: chooseNone,Show value,Show percent, orShow group name.Hide legend: hides the legend. For bar and line charts, the legend appears when you useSubgroup by.Show group icon: shows the icon of each group, if the group has one.Show total(donut chart): shows the total in the middle, asTotal sumorTotal count. It's on by default.
Hover and click
Hover over a value to see a tooltip. In bar and line charts grouped by a date, the tooltip also compares the value with the previous period, for example "vs previous month". Select a value to open the records behind it. The Others group can't be selected. Learn more about reports →
FAQs
Can I show two values in one chart?
Can I show two values in one chart?
No, a chart has one Calculation. Use Subgroup by in a bar or line chart to split the values by a second field.
Why can't I find Subgroup by?
Why can't I find Subgroup by?
Pie and donut charts have no subgroups. In bar and line charts, Subgroup by is hidden when Group others is on or when the Calculation is Average, Median, Minimum, or Maximum.
Can I change the chart type later?
Can I change the chart type later?
Yes, open Edit report and change Type. Settings that don't exist in the new type are hidden.
Are there other report types?
Are there other report types?
Yes! A report can show records from a database app as a number, a list, or a chart. See every report type in Reports →
Still have more questions? Find answers and get help from community experts in the Tape community →.
