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.
Note:
Reports and charts are only available on the Premium Plan. Learn more about plans →
A number report has no full screen.
Add a number report
Unlock the dashboard app (learn how →) and type
/.Under
Reports, selectNumber.Choose a source. To change the settings, hover over the report, click
•••at its top right, and selectEdit report.
Choose what to show
SourceandView: the database app and the records to include.Field: the field to calculate with. To count records, chooseCount allas theCalculation.Calculation: for aNumberfield, you can useCount all,Count empty,Count not empty,Percent empty,Percent not empty,Sum,Average,Median,Minimum, andMaximum. 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 itsSource,View,Field, andCalculation.
With a comparison, the report shows the difference instead of the value itself. Then set:
Direction:DefaultorReverse.Reverseswaps 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. ChooseAbsolute,Percent change, orPercent ratio.
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:
IconandColor.Number: chooseShow value, orShow placeholderto show a text instead of the number. Enter the text inPlaceholder.Unit: a prefix or suffix for this section.
Without conditional formatting, the report has one Icon and one Color for every value.
Format the number
Number format:Default,Compact, orCurrency. It isn't offered for percentages.Decimal precision: the number of decimal places, orAuto.Unit:None,Auto,Prefix, orSuffix. 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, orNumber 2.Align:Left,Center, orRight.
FAQs
Can a number report show a percentage?
Can a number report show a percentage?
Yes, choose Percent empty or Percent not empty as the Calculation.
Can I compare with last month?
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?
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?
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 →.
