Module 09 - Customizing Charts and Dashboards Flashcards
What are charts used for?
Provide visual display of data that helps people view patterns, trends, and exceptional data more easily.
What do Dashboards do?
Give users key information that relates to their jobs, displayed on a single screen.
You should create different dashboards for?
People who have different roles and responsibilities.
What are the most common items to include in a dashboard?
Lists and charts.
What are lists and charts based on?
Existing views determine the data displayed by lists and charts in a dashboard.
What are some ways a Chart can be displayed?
In a chart pane beside a view, embedded in a single record form, or as a component on a dashboard.
What are system charts?
Charts that are available to all users. It is a Solution component, and can only be created by users with permissions to customize the system.
What are personal charts?
Users can create something more specific for themselves individually. These personal charts can be shared with other users.
What should you consider when you design a chart?
The entity that contains the data you want to display, the fields that you want summarized as a series, how to summarize data, fields to use to group the data into categories, and the type of chart to best display your data.
How many series can you display in a chart?
Can display up to five series in a chart, grouped by one category, or one series that is grouped by one or two categories. You cannot display multiple series that are grouped by more than one category.
When you create a chart using the designer tools in the UI, you cannot configure…?
The view the chart will represent visually, the records the chart will include, the colors to use when the chart is displayed.
What can you do with the default charts created when you install the application?
Modify/delete and create additional ones.
System charts are included where?
With the entity they belong to when you export a solution package.
What is the meaning of the word “system” in the context of charts?
Unlike other components, these can be modified and deleted the same as any that you create. The word system in this context just means that these are charts available to all users in the organization.
How to modify or create a system chart?
Solution explorer > Entities > Charts > New > Save As to create copy > Configure chart > Save and Close
What role lets users create, modify, delete, assign and share personal charts?
All default Security Roles.
Are the same features available to use in personal charts as with system charts?
Yes, but personal charts can not be included in a solution package for deployment. Can be exported to XML and imported into target system without using a Solution.
How to modify or create a personal chart?
Navigate to entity you want to create a chart for > if chart pane is not already expanded, click the Charts bar > New Chart / or Save As to copy a system chart / More Commands, Save As to copy personal chart > configure > save > more commands > close designer to view
When should you create a personal chart?
When it is a specific requirement that not everyone must have.
How are charts different from other components?
You can export the definition of the chart and import the chart back into the same or different Organization without using a Solution.
Can you convert a system chart to a personal chart and the other way around?
Yes. You can’t do this with other components however.
What exactly does a chart display?
A series of aggregate (summarized) values, broken down by category.
When deciding on a chart display, what two approaches must you choose between?
One series of values divided into one or two categories, or more than one series with a single category.
What chart types are available in CRM?
Column, Bar, Area, Line, Pie, Funnel
If you select to display more than one series using a column chart, how does it show?
Displayed as columns next to one another / clustered column chart type.
If you have one series with two categories, what are your column chart subtypes available?
Stacked column or 100% stacked column.
When would you use a stacked column type?
When you must compare values between categories, and visual breakdown between each category is required.
When should you use a 100% stacked column?
When you must highlight how the “mix” of the subcategories changes between the records of each category.
Be aware of unpredictable effects of using stack chart subtypes with multiple series and single categories, why?
Depends on the order that you add the series, whether series measure comparable dimensions, and whether you select the chart subtype before or after you add each series.
What combinations can you do with Chart; Column (all types)?
All column, area, line charts
What combinations can you do with Chart; Area (all types)?
All column, area, line charts
What combinations can you do with Chart; Line?
All column, area, line charts
What combinations can you do with Chart; Bar (all types)?
Only other bar charts (of any type).
What combinations can you do with Chart; Pie?
None, pie chart supports single series only.
What combinations can you do with Chart; Funnel?
None, funnel cart only supports a single series.
What is the first option you’ll see on a new chart form?
View used for chart preview. You must select a public view from the list as you cannot select a personal view or special system view.
The View used for chart preview, does it affect your chart definition?
No, it is only used to preview your chart as you build it.
What kind of preview view should you use when creating a chart specifically for a dashboard?
Use the view that you intend to associate with the chart on the dashboard to better visualize.
Does the sort order of a view affect the preview or layout of a chart?
No, a chart can show data from fields even if the fields are not displayed as columns in the view that the chart is associated with.
When you create a personal chart, do you have the option of selecting view used for preview?
No, the chart designer uses the view that is already open next to the chart pane.
When you a configure a chart, you select fields to use as what?
Series and categories from the drop down list of fields defined for the entity. For convenience, it’s alphabetical, not how they actually show in the view.
Why is it important to use a property of the primary (parent) record when creating charts?
That way you can avoid creating a matching field, you can just use the field directly. Better accuracy, better maintenance.
A chart must have at least one what?
One series, one category.
Why do you use series in a chart for?
To control what data is displayed in a chart.
What are categories in a chart used for?
To split the series into different data points compared to one another.
What is a data point?
A single value displayed on a chart.
How to configure the first series for your chart?
Legend Entries > Select Field > Aggregate
What is the record set?
The collection of records that are returned by the filter query that is defined for the view.
What records are used in a chart? Regardless of method?
Only the records included in the current view are used in a chart that the records as associated with.
Aggregation method; Avg?
Calculates average of data values. Numeric only.
Aggregation method; Count:All?
The number of records in the record set. All field types.
Aggregation method; Count:Non-empty?
The number of records in the record set which have a value in the selected fields. All field types. Recommend not using with two-option.
Aggregation method; Max?
Highest value of the field in the record set. Numeric only.
Aggregation method; Min?
Lowest value of the field in the record set. Numeric only.
Aggregation method; Sum?
The sum of all the values of the field in the record set. Numeric only.
What is a best practice related to counting all the records in a record set?
Best field to select is primary key field as it will contain the GUID for the record and always contains a value.
When might the Add a series button be unavailable?
If you have two categories, or if you have already added the maximum of five series, or if you have a Pie or Funnel chart selected.
How to configure category for your chart?
Horizontal (Category) Axis Labels section of chart config form > Select Field > select field you want to use. To add a second category > add a category, repeat.
What happens when a date field category is not grouped?
It shows a data point for each unique date and time value in record set which may not provide a useful visualization or summary.
What happens if a field has a data type of date and time?
Date Time Grouping option set appears, default of Month. You can group by; day, week, month, quarter, year, fiscal period, fiscal year.