Create Dynamic Organizational Charts with Jedox

Create Dynamic Organizational Charts with Jedox

by Jedox 4 BeginnersNo Comments
Organizational charts are essential tools for visualizing the structure of teams and organizations. They help to showcase relationships between different roles or departments, making it easier to understand the chain of command or responsibilities. Using Jedox, you can create a dynamic and interactive organizational chart that automatically updates with changes from your spreadsheet data. Why Use an Organizational Chart? Organizational charts can be used for: Visualizing Team Structures: Understand how teams and departments are organized. Presenting Hierarchies: Show the chain of command or reporting lines. Onboarding New Employees: Help new hires quickly familiarize themselves with the organization. How to Create a Dynamic Chart in Jedox With Jedox widgets, creating an organizational chart becomes an easy process. Widgets allow you to dynamically pass spreadsheet data into an HTML/JavaScript code snippet to render visualizations. Here’s an example: Spreadsheet Setup: Organize your data in a parent-child format. Usually, this is the data that comes from Dimension. For this example, we will copy bellow table into dimension "OrgStructure" which will be used in...
Read More
Create Waterfall chart in Jedox

Create Waterfall chart in Jedox

by Jedox 4 BeginnersNo Comments
A Waterfall Chart is an effective way to visualize the cumulative effect of sequential positive and negative values, especially when analyzing changes in financial data like profit and loss statements, sales figures, or expense breakdowns. In this article, we will guide you on how to create a Waterfall Chart using Jedox. What is a Waterfall Chart? Before we dive into the steps, it’s important to understand the basics of a Waterfall Chart. This type of chart shows how a value changes as positive and negative values are added to the initial starting point. Typically, a waterfall chart starts with a bar that represents the initial value, followed by bars that represent positive and negative changes, and ends with a final cumulative value. Use Cases for Waterfall Charts: Financial Reporting: Show breakdowns of revenue, costs, and profit changes over time. Budgeting: Track actual versus budgeted performance, and isolate the factors driving the variance. Sales Analysis: Display how individual deals contribute to the overall sales figure. Steps to Create...
Read More
How to Create Bubble Chart in Jedox: A Beginner’s Guide!

How to Create Bubble Chart in Jedox: A Beginner’s Guide!

by Jedox 4 BeginnersNo Comments
Bubble charts are powerful visualization tools that can effectively represent three data dimensions simultaneously: the x-axis, y-axis, and the size of the bubbles. In Jedox, creating a bubble chart is a straightforward process that allows users to gain insights into their data relationships with ease. In this guide, we'll walk through the steps to create compelling bubble charts in Jedox, catering specifically to beginners. Understanding Bubble Charts: Before diving into the creation process, it's essential to understand the fundamental components of a bubble chart. Unlike traditional charts like line or bar graphs, bubble charts utilize bubbles to represent data points. The x and y-axes denote two dimensions of data, while the size of the bubbles indicates a third dimension. This unique representation enables users to visualize complex data relationships intuitively. Getting Started with Jedox: To create a bubble chart in Jedox, you'll need to access the Jedox Web interface. Once logged in, navigate to the Jedox Web Reports module to begin building your chart. Step...
Read More
HTML custom meter bar in Jedox

HTML custom meter bar in Jedox

by Jedox 4 Beginners6 Comments
Jedox is a powerful tool for spreadsheet-based planning, analysis, and reporting. One of its features is the ability to customize spreadsheets using HTML and CSS, allowing users to create visually appealing and interactive dashboards directly within their Jedox environment. In this beginner's guide, we'll walk you through the process of integrating HTML and CSS code into your Jedox spreadsheets, enabling you to design stunning visualizations and enhance the user experience. Step 1: Setting Up Your Jedox Spreadsheet First, open your Jedox environment and navigate to the spreadsheet where you want to implement custom styling. Create a new worksheet or open an existing one where you'd like to add visual elements. Step 2: Adding HTML and CSS Code Once you've selected your worksheet, you can start adding HTML and CSS code to customize its appearance. For example, let's say you want to create a meter bar to track project completion or budget consumption %. You can use the following code: <style> meter { ...
Read More
Creating a Combo Chart in Jedox

Creating a Combo Chart in Jedox

by Jedox 4 BeginnersNo Comments
Are you new to Jedox and want to learn how to create eye-catching charts for your reports? Combo charts in Jedox are a great way to present data that combines different types of information, and they are especially helpful when you want to visualize data in a simple and engaging way. In this beginner's guide, we'll walk you through the steps to create a combo chart in Jedox, and we'll explore the types of reports where this chart can be particularly useful. What is a Combo Chart? A combo chart in Jedox combines two different types of charts in one visual representation. You can have one chart type, such as columns or bars, representing one set of data, and another chart type, like a line chart, representing a different set of data on the same graph. This combination allows you to compare data sets that might have different scales or units of measurement. Creating a Combo Chart in Jedox Prepare Your Data: Make sure...
Read More
Geocharts visualisation in Jedox

Geocharts visualisation in Jedox

by Jedox 4 BeginnersNo Comments
In today's post, we'll explore the world of geocharts and how they can enhance your data visualization capabilities in Jedox. Specifically, we'll dive into using geocharts from Google and discuss how to leverage the Google API key to unlock their potential. What are Geocharts? Geocharts are powerful visual representations of data that allow you to display information on a geographic map. With just a few lines of code, you can transform your data into an interactive map. This helps you identify patterns, trends, and correlations across different regions. Why Use Geocharts in Jedox? Jedox, a BI and EPM platform, provides a wealth of features for data analysis and visualization. Geocharts offer a layer of insight, enabling you to explore data geographically and gain a deeper understanding of regional variations. Getting Started with Geocharts and Google API Key: To utilize Geocharts in Jedox, we'll need to integrate the Google Charts API, which powers these visualizations. Before we proceed, you'll need a Google API key,...
Read More