Cards

Top  Previous  Next

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)
2.Select Format…
3.Configure settings as appropriate (see below)
4.Click OK

 

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
oDefault
oFull (e.g. Month = October, etc.)
oAbbreviated (e.g. Month = Oct, etc.)
oNumeric (e.g. Month = 10, etc.)
oLong (e.g. Date-Hour = Saturday, October 15, 2016 10:57pm (en-US))
oShort (e.g. Date-Hour = 10/15/2016 10:57pm (en-US))
oTime 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:
oActual Value - Absolute Variation, Percent Variation
oAbsolute Variation - Absolute Value, Percent Variation
oPercent Variation - Absolute Value, Absolute Variation
oPercent 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.
oGreater is good - Displays positive if the actual exceeds the target
oLess is good - Displays positive if the actual doesn’t exceed the target
oWarning if greater - Displays a warning if the actual exceeds the target
oWarning if less - Displays a warning if the actual does not exceed the target
oNo indication
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.