reporting Archives - Jedox for beginners

Jedox Drill Features: Making Data Analysis Easy

November 18, 2023January 26, 2024 by Jedox 4 BeginnersNo Comments

In the world of data analysis, Jedox brings some handy tools to the table - Data Drillthrough and Drill Anywhere. Let’s break down what they do and why they matter to you. What's Data Drillthrough? Data Drillthrough in Jedox lets you quickly access extra info without jumping around different reports. For example, if you're checking out Orders by Product and want to know more about the Customers for each product, Drillthrough has your back. Using it is a breeze. In Jedox Views, just right-click on a number, choose Drillthrough, and bam! You get a new table with more details. You can customize it to show just what you need.And if you're using Web Spreadsheets, you can export the data as a CSV or XLSX file. One thing to keep in mind – the CSV file sticks to English number formatting, even if your language settings are different. Just import it into Excel, and you’re good to go. Here's a quick tip: in Drillthrough results,...

How to Create Success Charts in Jedox: A Beginner’s Guide!

November 4, 2023November 4, 2023 by Jedox 4 BeginnersNo Comments

Hey there, it's been a while! Today, I want to discuss creating your own success or progress charts in Jedox. These charts help us understand how things are going, like how much we sell and how much we make. We'll use info from our BikerBest data and look at four areas: East, West, North, and South. The chart will show us how much things changed from one year to the next. If something is red, it means it's the minimum value for that product in all the areas. If it's green, it means it's the maximal. We can even use different things like bars, rockets, or hearts to show the info. Fun, right? So, let's jump right in and learn how to make our own special chart in Jedox. Don't worry, it's not hard! Just follow these steps: Steps for creating a success chart Pick the Numbers: Choose the things you want to show in your chart from the BikerBest data. Maybe it's...

VisualVibe 275 – Jedox KPI Cards 🔵🔴🟢 🟡

August 8, 2023January 23, 2024 by Jedox 4 BeginnersNo Comments

Hey there, fellow data enthusiasts! After an intensive two-year endeavour, We are thrilled to reveal a visual solution for Jedox users worldwide. Presenting an inspiring colour palette exclusively designed for KPI cards across 10 diverse industries. This innovative palette isn't just about colours – it's a toolkit that promises to speed up your dashboard creation, aid in design decisions, and provide plenty of alternatives and examples. Say goodbye to hours spent deliberating over colours, fonts, and alignments – with our palette, you'll have the visual power you need to craft stunning, industry-specific KPI cards. Elevate your data representation and navigate your dashboards forward! 🚀🎨📈 NOTE: This feature only works with Jedox 2023.2 versions and newer. If you think some of these can fit your dashboards you can buy them here for symbolical 3.99 euros. NOTE: Only PayPal payments are possible at the moment. ...

Utilizing Multi-Selection Elements from Listbox

June 29, 2023July 20, 2023 by Jedox 4 Beginners7 Comments

Listboxes are an essential feature in Jedox, a powerful business intelligence and performance management solution. They allow users to select multiple elements simultaneously, enabling dynamic analysis and reporting. This article will explore how multi-selected elements from Listbox can be effectively used in dynaranges, subsets, and Palo formulas. We will also demonstrate how formulas can automatically sum the values from the selected elements, providing enhanced functionality for data analysis. Understanding Multi-Selection Listboxes Listboxes in Jedox provide a dropdown list of elements that users can choose from. By enabling the multi-selection feature, users can select multiple elements simultaneously, offering flexibility in data analysis. This allows for creating dynamic reports and calculations based on specific selections. We will present 3 use cases where you can see how Multi-Selection elements can be utilized: Leveraging Palo Formulas for Automatic Summation Palo is the powerful multidimensional database engine that underlies Jedox. With multi-selected elements from a Listbox, you can enhance Palo formulas to automatically sum the values from the selected elements....

How to create a top 10 list of a certain dimension?

December 30, 2021November 12, 2023 by Jedox 4 BeginnersNo Comments

The crucial part of every dashboard is the top 10 list analysis. Many companies would like to see what are their best-selling products, best performing months, or perhaps top 10 customers. Like other reporting tools, Jedox has a specific way to deal with it. So in order to achieve that we will use subsets. There are 3 segments to pay attention to: PALO.DATA - to create top 10 of anything we need to decide which data need to be sorted PALO.SORT - to sort data based on the value PALO.HIERARCHY to select only base level The last step is in the General tab to select Layout - Flat In the end, the report should like something like this: More on segments of the Palo subset can be found here. Report with an example can be downloaded here. ...