Overview
Cards are used to reflect data actuals and can be used in conjunction with additional comparative visualizations.
Each card can display up to three values: The Actual Value and, if using a target, two Delta values. Cards can additionally reflect a Sparkline.
Adding Data
Data fields are bound to Cards by dragging them to the Data Items Pane as an Actual, Target, Series or Sparkline.
Additionally, Hidden Data Items can be used for additional configurations, such as filtering, without displaying the field on the Dashboard Item.
Working with Card Data
Each Dashboard Item has different requirements for the data you add to it.
As mentioned above, Cards use Actuals, Targets (optional), Series and Sparklines.
When using a target, the aggregated value is compared to the target, displaying defined Delta values.
Each Data Item can be formatted by hovering over the item and clicking the options icon (right aligned down arrow).
• | Actual - Actual data to display on the Card |
• | Target - Target data to display on the Card |
• | Series - Data Item for which the Card is displayed. Using a Series allows you to see multiple Cards across several data items- Years, Projects, Employees, etc). |
• | Sparkline - Sparklines calculate and display the variation of summarized values over time. For Cards, the sparkline argument (date-time) will make this calculation based on the defined Actual (e.g. not the Target). |
Consider the following example:
Actual
|
Target
|
Series
|
Sparkline
|
Direct Hours PCT (Avg)
|
Target field (Max)
|
Employee Name
|
Work Date (Month)
|
This will reflect a Card for each employee indicating their billable percentage in relation to the target. You’ll also see indicators representing the Delta - the difference between the actual and the target.
Multiple Cards
Card Dashboard Items allow you to build multiple cards per dashboard item.
When filling the Actual and Target placeholders, you’ll notice a new set of empty placeholders appear. If applicable, drag and drop a new set of comparisons and the card will create a Value icon (stack seen in the upper-right hand corner of the dashboard item) which you can use to switch between cards.
TIP: If you’ve added data but don’t see it reflected, click the Refresh button above the Field List in the Data Browser (left-hand pane of the designer).
Formatting
Data added to Cards is automatically formatted based on the data type. That said, formats can be edited by clicking Options from the data item (Options Button- down arrow - becomes visible when hovering over the data field in the Data Items pane).
For instance, if using a percentage, you would likely need to change the format to type: Percent. Likewise, if using a date as your series, you may want to see that broken out in to quarters or months (etc.)
Numbers / Currency
To change the format for numbers or currency, hover over the data item in the Data Items pane and complete the following:
1. | Click the Options button (down arrow) |
3. | Configure settings as appropriate (see below) |
• | Format Type - Defaults to Auto. Options include: General, Number, Currency, Scientific, Percent. |
• | Unit - Unit to which values should be converted |
• | Precision - Defines the decimals to display |
• | Currency - Defaults to Dashboard global currency setting. Specific currency settings can be set here. |
• | Culture - Defines the currency cultures for currencies with multiple cultures |
• | Include group separator - Displays a comma between each numeric group (e.g. 1,000,000.00) |
Date Values
Date Values have several display options, listed when clicking the Options button. To change display settings, hover over the data item in the Data Items pane and complete the following:
1. | Click the Options button (down arrow) |
2. | Select the Date type (e.g. Year, Quarter, etc) |
3. | Optionally set the Format |
o | Full (e.g. Month = October, etc.) |
o | Abbreviated (e.g. Month = Oct, etc.) |
o | Numeric (e.g. Month = 10, etc.) |
o | Long (e.g. Date-Hour = Saturday, October 15, 2016 10:57pm (en-US)) |
o | Short (e.g. Date-Hour = 10/15/2016 10:57pm (en-US)) |
o | Time Only (e.g. Date-Hour = 10:57pm (en-US)) |
Delta Options
As mentioned above, Deltas represent the difference between the Actual and the Target used on the Card.
In addition to the Actual Value, each card consists of a primary and secondary delta value. The primary delta includes an indicator (whether the actual exceeds the target or not) and a number. The secondary, simply reflects a number.
Deltas can be configured by clicking the Gauge Options icon (gear to the right of the Actual/Target placeholders in the Data Items pane).
Delta Options include:
• | Value Type - Specifies which value type should be displayed as the Delta. For Cards, this is the Primary Delta. When setting the value type, the following secondary deltas are used: |
o | Actual Value - Absolute Variation, Percent Variation |
o | Absolute Variation - Absolute Value, Percent Variation |
o | Percent Variation - Absolute Value, Absolute Variation |
o | Percent of Target - Absolute Value, Absolute Variation |
• | Result Indication - Sets the logic for the delta indicator. Indicators include a green up-arrow (positive result), a red down-arrow (negative result) and a yellow warning circle. |
o | Greater is good - Displays positive if the actual exceeds the target |
o | Less is good - Displays positive if the actual doesn’t exceed the target |
o | Warning if greater - Displays a warning if the actual exceeds the target |
o | Warning if less - Displays a warning if the actual does not exceed the target |
• | Threshold Type - Further rules can be applied to when a visual indicator will be displayed in the result (e.g. display a green up-arrow only if the actual exceeds the target by 15% or $1500.00, etc.). Threshold Type defines the type of threshold to apply- percent or absolute value. |
• | Threshold Value - Sets the value for the threshold (e.g. 15%, $1500, etc.). |
Sparkline Options
As mentioned above, Sparklines calculate and display the variation of summarized values over time. For Cards, the sparkline argument (date-time) will make this calculation based on the defined Actual (e.g. not the Target).
Sparklines can be configured by clicking the Gauge Options icon (gear to the right of the Actual/Target placeholders in the Data Items pane).
Sparkline Options include:
• | Visible - Show/Hide the sparkline |
• | Sparkline view type - Defines how the sparkline should be visually represented |
• | Highlight min/max points - When checked, places a corresponding dot on the sparkline |
• | Highlight start/end points - When checked, places a corresponding dot on the sparkline |
Card Tools
Cards feature a specific set of design and data tools, available from the toolbar (some options are also available by right-clicking the chart).
All toolbar items feature tool tips which explain (in short) the core functionality of the toolbar option.
Data Tab
The Data Tab includes several options for data shaping.
• | Edit Filter - Use to add/edit filters on the grid based on displayed or Hidden Data Items. |
• | Clear - Clears all filters |
• | Single Master Filter - This sets the selected Dashboard Item (e.g. Cards, etc) as a Master Filter for all other dashboard items. Using a Single Master Filter you can only filter by one element in the selected item. |
• | Multiple Master Filter - This sets the selected Dashboard Item (e.g. Card, etc) as a Master Filter for all other dashboard items. Using a Multiple Master Filter you can filter by one or more elements in the selected item. Multiple items can be selected by using Ctrl+Click. |
• | Drill Down - Enables drill-in details for the Dashboard Item. For Cards, list multiple Series in order of detail - least to most. When enabled the gauge will reflect data for the top series, allowing you to click (double-click if also using Master Filter) through to each subsequent series, displaying values in relation to each. |
• | Cross Data-Source Filtering - Allows a Master Filter to affect data items displaying data from other data sources. |
• | Ignore Master Filter - Dashboard Items can interact with other dashboard items marked as a Master Filter. Clicking Ignore Master Filter removes interactivity. |
Design Tab
Cards allow the following design options.
• | Show Caption - Shows/Hides the caption (e.g. “Grid 1” displayed at the top left of the dashboard item). |
• | Edit Names - Used to configure display name for the Dashboard Item |
• | Auto Arrange - Automatically arranges the cards to fit the dimensions of the dashboard item. |
• | Arrange in Columns - Arranges the cards in a defined number of columns- configured by the Count ticker. |
• | Arrange in Rows - Arranges the cards in a defined number of rows- configured by the Count ticker. |
|