A card widget is a flexible and extensible way to display key metrics in a dashboard. Often you will need a simple container to showcase the most important key metrics in a way that everyone can easily understand. A card widget offers this simplicity to display data in an elegant way.
From version 2.8.14, Bold BI® offers two types of card widgets: KPI card and number card. You can find these card widgets in the widget panel of the dashboard designer. Let’s look at these card widgets in detail and see how to choose one for your requirements.
KPI card
A KPI card can be used to compare values using a formula. It can be either two completely different values or the same value at two different times. The following image shows the structure of a KPI card with all its integral elements.
Here are some examples of typical use cases of the KPI card.
- Comparing actual sales revenue and a target.
- Tracking website visitors (current month versus last month).
Configuring the KPI card
To configure a KPI card, you will need two numeric values: an actual value and a target value. This is the step-by-step process to configure a KPI card:
- Drag and drop the KPI card from the widget toolbox and resize it according to your layout.
- In the configuration panel, select Assign Data.
- In the Assign Data section, drag your actual value and the target, goal or comparison value to the Actual Value and Target Value sections, respectively. The KPI card will be configured as shown in the following image.
In the properties panel, you can change the KPI formula. Bold BI has built-in support for formulas to compare the actual and target values. The available formulas are:
- Percent of Target
- Percent Change
- Absolute Difference
- Percent of Difference
You can modify other properties, such as card title, actual and target value captions, font size, and color in the properties panel.
Using the KPI card to compare values over a period
The KPI card can also be used to compare a value over two different periods (e.g., current month versus last month). Let’s see the step-by-step procedure to achieve this requirement.
In my data, I have two fields, Order Quantity and Order Date. Using these two fields, let’s see how to prepare a KPI card to show the difference in the order quantity over two months.
- For the KPI card, we need a minimum of two measures, namely actual and target values. In our data, we have only one measure, which is the order quantity. Now, let’s create expression fields for order quantity for the last month and order quantity for the current month.
- In the data source panel, click the edit icon on your data source to open the data source designer.
- In the data source designer, click on the expression editor in the toolbar.
- First, we’ll create an expression to calculate the sum of the order quantity of the current month. Add a new expression in the editor and name it “Order Current Month”. Add the following formula, which basically checks whether the order is from the current month and then returns the order quantity. For all other months, the value will be returned as zero.
IF(MONTH([Order Date]) = MONTH(TODAY()), [Order Quantity],0)
- Then, create an expression for calculating the sum of the order quantity for the previous month. Add a new expression in the editor and name it “Order Last Month”. Add the following formula, which basically checks whether the order is from the previous month and then returns the order quantity. For all other months, the value will be returned as zero.
IF(MONTH([Order Date]) = (MONTH(TODAY()-1)), [Order Quantity],0)
Adding the Expression Fields
- Now that we have the required measures, we can go ahead and configure the KPI card using the values.
This is just an example of how to compare values over time. Using the above technique, you can derive your own comparison for any time period, for example, current year versus last year or quarter 1 versus quarter 2.
Configuring a card series
You can also configure the card as a series, as shown in the following image.
To configure a card series, you will need a dimension that can be a string or a date field. Drag the dimension to the series section to render the card series. In the case of a date field, you can also configure the aggregation.
Further, you can sort, filter, and customize the series using the options in the field menu.
Adding a sparkline
Sparklines are used for showing many trends at once as assets of small timelines. A sparkline could be optionally added to the KPI card to show the trend of your metrics. To add a sparkline, drag your date field to the sparkline section and choose the required aggregation.
You can also customize the various properties of the sparkline in the properties panel.
Configuring images and a background image
Optionally, you can add an image or background image to the card that expresses the KPI’s significance or progress, so the user can easily understand it.
To add an image or background image, you can easily upload an image from your local system, bind a URL from your data, or build a parameterized URL.
To upload a local image, in the properties panel, select the Local option from the Image drop-down. Now upload your image in .jpeg, .png, .gif, or any other format using the browse image option.
To bind the image URL from your database, select the URL option in the Image drop-down and, in the Assign Data section, drag your field containing the image URL to the corresponding section. The image will be rendered automatically.
To build a dynamic URL using parameters, drag your parameters to the image section. In the properties panel, choose the Image as a Parameterized URL. In the Pattern text box, add your dynamic URL by setting the parameters starting from zero as {0}, {1}, {2}, and so on.
For example, to show the US sales by county, I have added two parameters: state code and county code.
In the properties panel, I have added the flag URL by setting the parameters: state code {0} and county code {1}.
Flexible layout
The KPI card offers the flexibility to change the layout as needed. Each element in the card can be hidden and made visible only if necessary. For example, you can hide both the actual and target values and show only the KPI, as shown in the following image.
You can achieve this by hiding the left and right values (actual and target values) and their captions.
Similarly, you can move the values (actual, target, KPI) to any position based on your design. You can use the Type drop-down in any of the elements and choose your required value.
Here are some examples of the customized layout.
Conditional formatting
The KPI card has complete support for conditional formatting. You can modify the various properties of the elements such as colors, icons, and images based on conditions.
The conditional formatting option is available in the Formatting section of the properties panel. Enable Advanced Setting and add conditions and formatting in the dialog.
The conditional formatting dialog even allows you to add a condition based on a completely different field, rather than the one already configured. You can also choose various condition types and formatting as shown in the following image.
The following example shows a KPI card configured in a series to show the weather forecast of the week. The images are dynamically configured based on the weather conditions.
Number card
The number card is similar to the KPI card, except that it can be used to show a single numerical value. Unlike the KPI card, the number card doesn’t compare two values. You can configure it to show a single measure. The structure of the number card is given in the following image.
To configure a number card, drag a numeric field to the Measure section in the Assign Data panel as shown in the image.
You can also configure the number card as a series and add sparklines, an image, background image, and other formatting as supported in the KPI card.
Conclusion
I hope this blog provided a clear overview on how to configure, customize, and use card widgets in Bold BI® to visualize the key metrics. Based on your own requirements, you can choose the one most suited to your needs. If you have any questions, please post them in the comments section. You can also contact us by submitting your questions through the Bold BI website or, if you already have an account, you can log in to submit your support question. If you are new to Bold BI, get started with Bold BI by signing up for a free trial and create more interactive business intelligence dashboards.
Top comments (0)