Data and Analytics Management III-IV-V Flashcards
A “____” determines which records and fields are available in a report.
report type
“_____“can be used to report on historical data.
`Reporting snapshots
Combine up to “__” blocks in one report with joined reports
5
Fields cannot be hidden and will always be available to users when using this report type
standard report type
Fields can be hidden to prevent the field from being used when using this report type
Custom report type
Users can create “____” types if none of the standard or pre-made custom report types meet the report requirements.
custom report
“___” reports is just a list of records displaying their fields
Tabular
Data in a “___“report contain grouped records and subtotals.
summary
Data in a “____” report involve records that are grouped or summarized by rows and columns.
matrix
“___” reports are used for analyzing Salesforce data across multiple report types or getting multiple simultaneous views of an object.
Joined
“__” fields can be used for grouping, filtering, and categorizing report values based on defined criteria.
Bucket
“____” fields can be used to find the sum, average, highest, or lowest value of a numeric column in a report.
Summary
Four (4) types of summary can be used for a custom summary formula: They are
SUM, AVG, MAX and MIN.
Custom summary formulas can be created for these 3 grouping type reports At least one grouping is required.
summary, matrix and joined reports.
“___” Filters can be used to display records based on whether or not they have child records of a particular type.
Cross
“___” can be added to combine filters in a report with AND, OR, and NOT conditions as well as parentheses for condition priority
Filter logic
When report filtering on a picklist field, “____” can be selected to limit results to records that are blank or contain ‘null’ values.
‘No Selection’
Several “____” are available for displaying report data in the form of bars, columns, lines, shapes, or other elements.
chart types
chart types can be created on these three report types
summary, matrix and joined reports.
Charts provide a “___” of the information in the report.
visual display
“____“charts show changes in value over time, e.g., monthly leads by month. can move up diagonally if the hoizontal and vertical value is steadily rising
Line
“____“Chart displays report data in the form of a donut that consists of wedges where each wedge represents a grouping.
Donut
A “____” chart can be used when there are multiple groupings in an ordered set to show proportions among the set.
Funnel
A reporting snapshot can be configured to run on what 3 time intervals
daily, weekly, or monthly.