Reporting Flashcards

1
Q

How many levels of groupings on a Summary Report type?

A

3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How many levels of summarization in a Matrix Report type?

A

2 levels for rows and columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How many blocks can be shown in a Joined Report type?

A

5 blocks (1 standard or custom report type)
2k records per block
upto 10k records total

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What features are not supported in a Joined report?

A

1) Bucket fields
2) Cross filters
3) Rows to Display filters
4) Conditional Highlighting
5) Reporting snapshots
6) Report subscriptions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the limits on report filtering?

A

3 cross filters per report and 5 sub filters for each cross filter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Custom Summary Formulas do what?

A

saves effort of having to create a formula field if the value is only required in a report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Customer summary formula limits

A

1) Can be defined on number, percent, and currency
2) four types of summary (avg, max, min, sum)
3) limited to 3900 chars
4) Up to 5 formulas can be defined per report
5) at least one grouping is required (cant do it on tabular

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Row level formula limits?

A

Only one row level formula per report
up to 3 unique fields can be referenced
dashboard supports
created for a report which requires info not available in standalone field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Standard Report Types?

A

using a with relationship between objects selected

reveal all fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Custom Report Type?

A

up to four objects/levels (primary and 3 related)
can hide custom fields
can use with or without between objects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What controls fields that are available for the report in a custom report type?

A

Field Layout screen

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

When a dashboard is refreshed, is it refreshed for everyone or just the user who refreshed it?

A

Everyone

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Dashboards can be automatically emailed to users on a refresh?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is a Dynamic Dashboard?

A

configured to only show data that a given user has access to

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

how many dynamic dashboards can you have?

A

5 enterprise

10 unlimited

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What does a running user option do for dashboard?

A

displays data that the running user has access to for all users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Where are dashboards stored?

A

controlled by folder

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

what are options to view dashboard?

A

view as person who created, another person, or themselves (this can be controlled though)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Bar Chart is used for?

A

shows values as horiz. or vertical lengths.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Stacked bar chart is used for?

A

shows proportions between values in each grouping and each groupings total.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Line chart is used for?

A

use for displaying changes over time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Donut chart is used for?

A

multiple groupings, show proportion of a single value for each grouping against the total

23
Q

Funnel Chart is used for?

A

used to show the proportions among multiple groupings in an ordered set

24
Q

Scatter chart is used for?

A

one or two groups of report data plus measures

25
Guage chart is used for?
displays a single value towards a goal
26
Metric is used for?
one key value (such as a total of something)
27
Lightning table?
up to 200 records and 10 columns from any field made available in report type
28
What happens when dashboard is not refreshed in 7 days?
Prompt user to refresh
29
Folders can be shared with?
1) users 2) public groups 3) roles 4) role and subordinates
30
What are three levels of access to folder?
View --> view Edit --> edit/delete report Manage --> edit delete folder
31
What controls what records are seen in a report?
Sharing Settings | if public, everyone will see same records in report
32
what user permission needed to create reports in private folders? in public folders?
Create and Customize Reports (private) Report Builder (public)
33
How can it be ensured that a dashboard is not accessed by a someone not authorized?
Store dashboard in appropriate folder they should have access
34
What are the different levels of access available for sharing a report or dashboard folder?
Viewer Editor Manager
35
What are the different types of reports?
Tabular, Summary, Matrix, Joined
36
Which report format can be used to display a Sales Rep Performance Scorecard?
Joined report
37
Which dashboard component(s) can be used to display a grand total?
Gauge and Metric
38
Which report format does not support bucket fields and cross filters
Joined report
39
Which report formats support custom summary formulas?
Summary, Matrix, Joined
40
What impact does the sharing model have when running reports?
Security and sharing model settings are applied when a user runs a report so they will only have access data they are supposed to
41
What customization options are available in reports?
``` Define filters Define/Name ranges in bucket fields Summarize number/currency fields conditional highlighting of summarized values custom summary formulas ```
42
What data will a dashboard display?
data a user has access to if defined as 'dynamic' or run as 'running user'
43
What are the different dashboard components?
``` chart guage metric table visualforce ```
44
When are dashboard refreshed?
manually or scheduled: daily, weekly, monthly
45
Why would a custom report type be created?
to specify types of related records included (with/without) and add additional fields (fields related to a lookup)
46
What relationships are possible when creating custom report types?
with and without
47
How many levels can a custom report have?
4
48
Are standard reports types defined by with or without?
with
49
After adding a group to a report in LE, what can be shown or hidden from the bottom of the preview pane?
detail rows grand total subtotals (by togging switches down there)
50
what are some capabilities available on a joined report run page in LE?
Adding a chart editing filters adding report to a dashboard sorting columns/groups
51
In LE, what is required for using a joined report as a data source for a dashboard component?
A chart must be added to the joined report
52
What is the max number of components a dashboard can have?
20
53
What report types can be converted to a joined report?
Tabular, Summary, Matrix (all of them)
54
What two permissions are needed to create custom reports that all users can view?
Manage Public Reports | Create and Customize Reports