Layout
Discussion List
-
Modify Format in Label Text Algorithm
Hi, I am trying to format a value displayed in a Text object in Board 14. My goal is to show the progress of the current period as a percentage with one decimal place, for example: 17/22 = 77.3% I first created the full calculation in a single Text object expression. Since the formatting did not work as expected, I split…
-
Level 300: Module 305 /306 - Planning expansion: New product planning based on drivers
Hello everyone, I’m unable to tick the boxes on my list, yet in the test module it asks me to check some boxes. Any idea why? Screenshots attached. (1st: my list, 2nd: the training)
-
BOARD 15.1: KPI Labels show N/A instead of 0 when no records match the current selection
Hi Board Community, I'm working on a dashboard in BOARD 15.1 and looking for a reliable way to display 0 instead of N/A in KPI Labels when no records match the current selection. The example below uses generic names to describe the configuration. Expected behavior The dashboard contains KPI Labels showing record counts by…
-
Move or copy screen from S1 to C1
Morning, how do I move a newly created screen from S1 to C1? br, Maik
-
Field Notes: User-Configured Reports
Featuring: Samir Jones is a Developer - Attollo AB and Community Captain In large-scale Board environments, managing unique reporting requirements for hundreds of users can quickly become a maintenance nightmare. As a developer, you often find yourself caught in a cycle of creating near-identical screens to satisfy…
-
Monthly Customer News Update - September
The 'What’s Possible Now' Edition New capabilities matter most when you know how to put them to work. Summer may have slowed a few things down. Board wasn’t one of them. Since our last edition, Board 15.1 has arrived, a full library of Board TechTalks is now available to you on demand, and there are new ways to learn,…
-
Waterfall Chart with text cube in X - Axis
Hi Everyone, I need guidance on creating a dynamic day-level waterfall chart in Board. I have a cube storing daily cash data by Day and Business Unit, along with two additional cubes storing major movement amounts and commentary at the same level. The requirement is to dynamically display the movement commentary along with…
-
Row Template/Block Format Question
HI! we do have P&L reports with ACT, BUD and PY columns and some abs./% deviation columns. Currently we do have a row template highlighting specific rows with colour and bold numbers (e.g. Gross Profit I, Gross Profit II etc.) - we now need to make the numbers in %dev.-columns in cursive, but this is not working at all.…
-
Board Data View KPI Production
Can I get assistance for any blueprint how to calculate for the following KPIs using Board data view layout? I have a flat file data source data reader created and loaded, with entities, and one cube (amounts). any general overview assistance is greatly appreciated: Contracts % of Revenue = Contracts / Revenue. Temporary…
-
Header Title Font Colour
Hi everyone, I would like to adjust the screen title that is shown in the header. Ideally I'd either change its font color so that it is no longer visible, or hide the title completely. What I have tried so far: I set a header background image in the System Administrator settings. The image itself works fine, but the…
-
How to reduce the Icon size of On-Screen Tips?
Hi Board Team, Just a quick question about the On-Screen Tips icon. How can I make the icon smaller? I've seen a smaller icon displayed on other screens, so I assume this option exists somewhere. Unfortunately, I can't find where to adjust the icon size in Version 14.5. Thanks a lot
-
Restricting the disabling of sorting on column in flexgrid
Hi Team, I have a flex grid object, there i am using a multiple sorting on it, If i click once, it changes to ascending order ↑ If i click again, it changes to descending order ↓ If i click it again, it removes the sorting order. it exceeding the no. of clicks so, here customer don't want to remove the sorting on the…
-
Hide Total Column or Grand Total Column in Data Views
Hi, I’d like to hide the “Grand Total” column on a screen. The sum across multiple years doesn’t make sense. Unfortunately, I haven’t found anything so far that helps me with this. Some of my colleagues have also encountered this use case in other projects and were unable to resolve it. Can you help us? More details are…
-
How can I correctly display a revenue ratio?
How can I correctly display a revenue ratio (costs as a percentage of of revenue) in Board?No matter what I've tried so far, as soon as I have row and column totals, the ratios for the totals are not displayed correctly. I used a cube without an account entity, into which I only wrote the revenue. I used the original cube…
-
Advanced Smart Import
1. ABSTRACT The Smart Import object facilitates the upload of data (master data, transactional data) to Board. Before, Dataviews with line number entities or CSV blob cubes with export/import procedures were required to upload the data. In addition, a complex check logic (if implemented at all) was required to detect wrong…
-
How to display the unbalanced hierarchy in the collapsed view in the dataview?
Hello Board Team, A client has an Account entity set up as Unbalanced Hierarchy. They have a simple dataview with 1 block using a cube with actuals, and they want to display Account entity in rows in a collapsed view: e.g. to show "+ 1P SVOD line" by default, and when end-users click on it, 3 revenue sales lines show up,…
-
Dynamic File Name based on Entity Member.
Hi Guys, I am exporting a layout to the server, and I need the output file name to be dynamic based on the selected entity member in the procedure. For example: If the Data Category is Entity and the selected member is Actuals, The generated file name should be: Actuals_Report.csv Could anyone guide me on how to achieve…
-
How to refer any particular cell or range of few cells irrespective of entity codes in nexel?
Hi Team, I am facing an issue with nexel function, I have table with two blocks with month as column Now i am trying to refer the 1st cell of the 1st block which means in Jan column to 1st cell of second block in the same way i need to sum of all 12 months and display it in 2nd cell of the 2nd block Now I can easily do…
-
Flex Grid Configuration Issues : Locked Cells and By Column properties issues.
Hi everyone, I'm trying to recreate the Flex Grid layout shown in the screenshot (I've hidden the cube names, hopefully that's not an issue). In Cube 3 (Block C), I enabled Data Entry and set Detail By = Column: Month. Data entry is locked by Condition Block G, which is an algorithm also configured by Month. Due to the…
-
Conditional formatting of data labels in the Waterfall Chart Object
Hi everyone, I'm working with the Waterfall Chart Object and I'm trying to apply conditional formatting to the data labels (the values displayed above each bar). My goal is the following: Positive values → label displayed in green Negative values → label displayed in red For example: +200 → Green label+180 → Green label+30…
-
How to calculate the data among the entity members of same entity
i have a entity called "Test" members of its entity are Test1, Test2, Test3, Test4 Now i need to do a calculation such that Test1+Test2-Test3 and store this value against Test4. can you please help me in this. Thank you for support
-
Missing alignment of the legend in the cartesian chart
Hi Team, Initially, I have cartesian chart with single data block. Then the alignment is fine. Now due to requirement change I have to add another block despite it is hidden. The alignment of the names is not matching with the icons in the legend. Could anyone please help me to fix this issue. Thanks & Regards, Vanam Pavan…
-
Is Row Number/Counter Possible in Export DataSet
i am trying to export a report and i want a row number, or else it would be helpful if i can insert the row number/counter values through data reader in etl
-
Quarter to date with detail by, but having one block referencing full quarter.
Hi! The intent of this screen would have been to see what QTD actuals are as of month 2 (february) close. Compare february QTD actuals to february QTD forecast Detail #1 by month Compare full quarter forecast to QTD actuals to then calculate remaining forecast to spend I believe I can do #1 by having two pagers, one for…
-
Need help with Report building, particularly Total By
Hi, I would like to ask for some tips about the best practices with regards to building an archive report. We have an archive cube with the following 6 entities: Month, Reporting Year, Version, Business Area, Currency, PnL. PnL is the biggest one with <200 members, all of the others are <20 members. I have a screen…
-
Introduction to Board: Analysis and Reporting OnDemand
In Module 1 Quick Layout option is not available