Hide and show setting with canvas

Hide and show setting with canvas

Back in 2023, Jedox introduced the new component of Canvas. Year after, it is widely used by organizations and Jedox users. Apart from standard functionalities which we covered: https://jedox4beginners.com/canvas-kpi-cards-in-jedox-a-comprehensive-guide/ today we present a trick of how to hide combo boxes, labels, checkboxes and rows individually in a report for a smoother look and feel for the customer. For this exercise, we will show how this combines with the reports coming from our BPA models. In case you want to learn more about them you can check it here. https://knowledgebase.jedox.com/models/accelerators/best-practice-accelerator.htm You can hide a whole stack with one setting. Happy canvassing! ...
Read More
Charting New Horizons: Navigating Stock and Commodities Markets with Jedox πŸ“ˆπŸ“Š

Charting New Horizons: Navigating Stock and Commodities Markets with Jedox πŸ“ˆπŸ“Š

Hello dear Jedox beginners, In this post, we will take an unusual path and instead of connecting to usual business tools, we will try to extract the commodity and stock data. To do that we will connect to free API at https://www.alphavantage.co/. Alpha Vantage is a financial data provider that offers a wide range of financial market data and services. It provides access to historical and real-time market data for various asset classes, including stocks, cryptocurrencies, forex (foreign exchange), and more. At this moment we will focus on commodity data. The connection will be Rest type and the extract will be from JSON. Technical details for commodities API Resource is: https://www.alphavantage.co/query?function=${Commodity}&interval=daily&apikey=${API} where API Parameters are ❚ Required: function The function of your choice. In this case, function=BRENT which is crude oil. A list of the commodities will come with the model ❚ Optional: interval By default, interval=monthly. Strings daily, weekly, and monthly are accepted. ❚ Optional: datatype By default, datatype=json. Strings json and csv are accepted with the following specifications: json returns the time series in JSON format; csv returns the time series as a CSV (comma-separated value) file. ❚...
Read More
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