COG170 Summaries Questions With Complete Solutions

Workbench summaries group and aggregate on the data returned by what? correct answer: the PAF columns Workbench Summary. True or False In order to be available to a summary, the column has to be displayed correct answer: False: Columns do not have to be displayed to be available to a summary To group or aggregate by an element not already available in the report, add a new column on the Display tab, whether as an Available Column or Selected Column Workbench: The biggest differences between summaries in the explore tab and summaries created in Report Settings are as follows: correct answer: 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? correct answer: Badges are easily digestible graphics representing a single data point from a table or graph component Where do you Build Badge in Component Editor correct answer: To build a badge in the Component Editor, navigate to the Badge section of the Output Format form When should you used SlicerDicer Components? correct answer: Data that you want to see every time you log in Data related to other metrics and graphs on an existing dashboard 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? correct answer: 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? correct answer: 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 Average Percentage correct answer: None of them are affected by Null values If the data is somehow obfuscated, what might be the issue? correct answer: The wrong summarization function was used. Once data has been grouped, summarization functions aggregate the data and define how it should be displayed for each group. Choosing the wrong summarization function can obfuscate the data. There are several common errors made when choosing how to summarize. Follow these rules. correct answer: DO NOT use a count function on numeric data to find total amount. DO NOT use count unique unless you want to display "number of different values." When using an average function, find out if the column stores a NULL or a 0 when no data is entered. In SlicerDicer how is grouping changed. correct answer: By adding slices. SlicerDicer Summarization Functions correct answer: The measures used by a SlicerDicer population control which summarization functions are used. All measures can be counted