Layout
Discussion List
-
Row style template overrides Block Format symbol: “bps” on 3 rows only, numeric
Hi everyone, I’m working on a P&L report in a Data View and I’m stuck on a formatting issue involving the Row style template (Data model > Format) and the Block Format. I’ve spent quite some time on it and tried several approaches, so I’m sharing everything in detail in the hope someone has a clean solution. Environment:…
-
Field Notes: Improving Board Procedure Performance
Author: Neha Hasija is a Senior Consult and Board Community Captain. In my project work, I have seen procedure run time become a practical concern when calculations repeat across a large Layout or an export evaluates more combinations than needed. Working through these cases taught me to look for the workload behind the…
-
how to configure match() function in a dataview?
Hello, I want to use the match() function to search a piece of text within a text. The board manual https://help.board.com/docs/algorithms states: My questions are: I build a basic layout using number algorithm match("shorter", a) and it displays the value 0, although for member 002 it should display 11 (because the word…
-
Unable to stop the rolling up of color alert on a algorithm block where UBH entity as by row.
Hi Team, I have applied a color alert on algorithm column in dataview where I have UBH entity as by row, So the alert is rolling where it not supposed to rollup. I have enabled disable Unbalanced hierarchy in Rules. yet it rolling up. could anyone help me to fix this issue. Thank you for the support.
-
Can Board download data once in two different dataview
Hi All, I wonder like to know if board have a way to download two different date view in one time?
-
Is the any other object that can have a drop down functionality like pager.
Hi Team, we need a kind of object that can display like drop down functionality of pager object then if we select any one item that need to trigger a procedure automatically once selected. Please help me if we have any such object or functionality. Thank you for your support.
-
@Selection doesn't apply to chart objects
Here we are trying to display the selected month selection as heading for the start and end blocks for the waterfall chart. using @month substitution formula as how we are using in data view object . we are using the new waterfall chart object. So here is the idea link, please vote for this idea if you consider this…
-
Cartesian chart: hide the category axis line (and ticks) while keeping the axis labels visible
Hi everyone, I’m building a “Performance globale” screen with several Cartesian charts (line series), and I need to match a design mock-up provided by the business. I’m attaching two images: Image 1: the current result in Board. Image 2: the expected result (mock-up). Expected result The category axis shows the month…
-
How to display a superscript Δ in a Data Block Heading (e.g. ΔB26)?
Hi everyone, I have a question regarding the formatting of Data Block Headings in Board. In my report, I have six tables, and the business requirement is to display the following labels ( Please see the two attached screenshots for reference: the first shows the expected format, and the second shows the result I get after…
-
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