Skip to main content

Number report

Show one value from a database app, such as a count, sum, or average. Compare it with another value, format it, and color it by result.

Written by Leo

Use a number report when one figure matters more than the details. You can compare it with a target or with data from another source, and color it by the result.

Number reports with totals for this month and comparisons to last month

Note:

Add a number report

  1. Unlock the dashboard app (learn how →) and type /.

  2. Under Reports, select Number.

  3. Choose a source. To change the settings, hover over the report, click ••• at its top right, and select Edit report.

Typing /num in an empty line of an unlocked dashboard app, selecting Number under Reports, searching Stories under Select a database, and choosing it, after which the new number report shows 11

Choose what to show

  • Source and View: the database app and the records to include.

  • Field: the field to calculate with. To count records, choose Count all as the Calculation.

  • Calculation: for a Number field, you can use Count all, Count empty, Count not empty, Percent empty, Percent not empty, Sum, Average, Median, Minimum, and Maximum. For other field types, only the count and percent options are available. Learn more about calculations →

Compare with

Use Compare with to show how the value relates to something else:

  • Off: no comparison.

  • Value: compare with a fixed number you enter.

  • Data: compare with data from another source. Choose its Source, View, Field, and Calculation.

With a comparison, the report shows the difference instead of the value itself. Then set:

  • Direction: Default or Reverse. Reverse swaps the two values, so a value below the comparison gives a positive result. Use it when a lower value is better, for example open tickets.

  • Difference: how to show the gap. Choose Absolute, Percent change, or Percent ratio.

The open report menu of the number report Contracts vs last month with Compare with set to Data, the compare data, Direction, Difference, and Conditional formatting

Conditional formatting

Turn on Conditional formatting to style the report by result. There are three sections: Neutral, Positive, and Negative. Tape picks the section by the value the report shows: Neutral for zero, Positive for a value above zero, and Negative for a value below zero.

In each section you can set:

  • Icon and Color.

  • Number: choose Show value, or Show placeholder to show a text instead of the number. Enter the text in Placeholder.

  • Unit: a prefix or suffix for this section.

Without conditional formatting, the report has one Icon and one Color for every value.

The report menu of a number report with Conditional formatting turned on, the tabs Positive, Neutral, and Negative, and Icon, Color, Number, and Unit for the Positive section

Format the number

  • Number format: Default, Compact, or Currency. It isn't offered for percentages.

  • Decimal precision: the number of decimal places, or Auto.

  • Unit: None, Auto, Prefix, or Suffix. With a prefix or suffix you can enter text, for example "USD" or "kWh". With conditional formatting on, you set the unit in each section instead.

  • Size: Text, Heading 1, Heading 2, Heading 3, Number 1, or Number 2.

  • Align: Left, Center, or Right.

The report menu of a number report with Conditional formatting off and the settings Icon, Color, Size, Align, Number format, Decimal precision, and Unit

FAQs

Can a number report show a percentage?

Yes, choose Percent empty or Percent not empty as the Calculation.

Can I compare with last month?

Yes, set Compare with to Data and choose a source and a view that contain last month's records, for example a view filtered to last month.

Why can't I choose Sum for my field?

Sum, Average, Median, Minimum, and Maximum are only available for Number fields and number results of Calculation fields.

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 →.

Did this answer your question?