Canvas KPI Cards in Jedox: A Comprehensive Guide

Canvas KPI Cards in Jedox: A Comprehensive Guide

Canvas KPI Cards in Jedox provide a powerful way to display summary measures from your data and assess the status of an action against a target or comparison value. They were introduced with version 2023.2 and expanded Canvas capabilities to another level. These visually engaging KPI Cards allow users to track and communicate progress toward measurable goals easily. In order to start using them you need to create a new Canvas type of report in the Report Manager. After that, from the left side, you will be able to see the Components section. Format Tab When you add a KPI Card to your Canvas, a dialogue box with two tabs appears on the right side of the screen. The Format tab allows you to customize properties such as name, width, padding, margin, background colour, and radius. Moreover, the Format tab's lower section allows you to personalize the font style and alignment of different sections within the KPI Card, such as Title, Value, and Comparison. Data...
Read More
Jedox ComboBox: Presenting Future Dates with Ease

Jedox ComboBox: Presenting Future Dates with Ease

Jedox, the versatile business intelligence and performance management solution, offers a range of features to streamline data analysis and visualization. In this article, we'll dive into the capabilities of Jedox ComboBox and explore how it can be used to present future dates in a user-friendly manner. We'll guide you through a step-by-step process to leverage this functionality, opening up new possibilities for data exploration and decision-making. So let's get started! As a pre-requirement, we will need a Day dimension in some of your databases. Step by Step: Presenting Future Dates in Jedox ComboBox 1: Retrieve the Current Date using TODAY(). 2: Convert the Current Date to the Day Dimension Format. 3: Return the DayValue Attribute: In this step, we retrieve the DayValue attribute, which represents the current date in integer format. 4: Set a Named Range for Attribute Filtering: We establish a named range in Jedox, which allows us to conveniently filter the DayValue attribute. 5: Create a ComboBox and Apply the Attribute Filter. 6: Get...
Read More