COG170 Summaries Questions With
Solutions
Workbench: The biggest differences between summaries in the explore tab and summaries
created in Report Settings are as follows: 1﴿ The summaries can be saved as views of the
report results only. This means they will be available to all users who run the report, but only
within the results, not on a dashboard.
2﴿ The summaries can be grouped and aggregated based on only the displayed PAF columns, not
those listed as "Available" in the Display tab.
What is a Badge? Badges are easily digestible graphics representing a single data point
from a table or graph component
Where do you Build Badge in Component Editor To build a badge in the Component
Editor, navigate to the Badge section of the Output Format form
When should you used SlicerDicer Components? Data that you want to see every time
you log in
Data related to other metrics and graphs on an existing dashboard
, COG170 Summaries Questions With
Solutions
A query you want to be able to revisit regularly and modify or re‐evaluate for unique cases
When should you not use SlicerDicer Components? Many dashboard components are
shared across dashboards, to standardize understanding of certain reports and metrics.
SlicerDicer is not intended for distributing a shared session across a large population. You should
not use SlicerDicer components to: Track a predefined and unchanging metric across
departments/users. Use a metric‐based component instead. See the Dashboard Metrics lesson for
more information. Find a small set of records on which you need to take immediate action or see
real time details. Use a Reporting Workbench report instead.
When grouping, what do you have to pay attention to? When grouping, pay close
attention to duplicate values, this could cause unrelated rows to be summarized into the same
group.
Which of these functions is affected by NULL values?
Count
Count Unique
Sum
Solutions
Workbench: The biggest differences between summaries in the explore tab and summaries
created in Report Settings are as follows: 1﴿ The summaries can be saved as views of the
report results only. This means they will be available to all users who run the report, but only
within the results, not on a dashboard.
2﴿ The summaries can be grouped and aggregated based on only the displayed PAF columns, not
those listed as "Available" in the Display tab.
What is a Badge? Badges are easily digestible graphics representing a single data point
from a table or graph component
Where do you Build Badge in Component Editor To build a badge in the Component
Editor, navigate to the Badge section of the Output Format form
When should you used SlicerDicer Components? Data that you want to see every time
you log in
Data related to other metrics and graphs on an existing dashboard
, COG170 Summaries Questions With
Solutions
A query you want to be able to revisit regularly and modify or re‐evaluate for unique cases
When should you not use SlicerDicer Components? Many dashboard components are
shared across dashboards, to standardize understanding of certain reports and metrics.
SlicerDicer is not intended for distributing a shared session across a large population. You should
not use SlicerDicer components to: Track a predefined and unchanging metric across
departments/users. Use a metric‐based component instead. See the Dashboard Metrics lesson for
more information. Find a small set of records on which you need to take immediate action or see
real time details. Use a Reporting Workbench report instead.
When grouping, what do you have to pay attention to? When grouping, pay close
attention to duplicate values, this could cause unrelated rows to be summarized into the same
group.
Which of these functions is affected by NULL values?
Count
Count Unique
Sum
