-
Numbered Axis
Is there a way to number the axis similar to an excel spreadsheet? Maybe I am missing something, but I cannot find any details on this in the reference manual or on here.
-
Pacer vs. Selector
Hi there, I have a screen in which I have a pacer which is filtering months. I created a procedure that should apply the filtered month to the next screen. However it doesn't do it. Therefore am I correct that you need to have a selector always when you want to screen selections in a procedure? Thanks, Maik
-
How to use Nexel to select custom time periods
*NEW - includes video demonstration. Build Along with Board Follow along as we bring this step-by-step guide to life. https://player.vimeo.com/1105912052 Quick reference: 4:32 - Custom time period selector 7:23 - Create members 8:38 - Create the cube 10:09 - Create Nexel layout > complete Nexel process begins here 1.…
-
Expanding a column for a drilled Data View
Hi all, after drilling in the main Data View, I'm left with another Data View that has an "collapsed" column (screenshots below) If i manually expand the column and then save, once i go out the layout the column remain half hidden. I don't seem to find any option in the settings to expand the first column. How can i make…
-
Dynamic Color Alert
Hi All, I am seeking a solution for an issue I am currently facing. Specifically, I require a dynamic color alert, but it appears that I need to select the number to link to the color. Unfortunately, I am unsure of the maximum number that should be used. Kind regards, Andrea
-
Dynamic Visibility of Data Blocks (Hide When No Data is Present)?
I have a data view object that is storing 5 different report types in 5 different cubes. The rows are dimensioned by fiscal year and month and there is no dimension on column, meaning that the 5 columns are the 5 data blocks in the layout. I would like to hide data blocks (Legal Income Statement & Legal Balance Sheet in…
-
NEXEL + CROSSVIEW + COUNTIF not working?
Hi all, On the row "0" of the second layout, I tried a deepest entity formula Nexel: =COUNTIF([#Data;@a;*;Range.Vertical],"=A") but can't make it count how many "A" lies on the first layout. I've also tried: =COUNTIF([#Data;@a;*;Range.Vertical],"A") =COUNTIF([#Data;@a;*;*;Range.Vertical],"A") And many others, but can't…
-
Module 213 - No data for Italy GBP on Profit and Loss Statement screen ?
Hello, I am triple-checking all the steps of module 213 and I still don't understand why I've got no data showing up on the Profit and Loss Statement screen on the GBP tab with country selector on "Italy", while I do have data for the UK GBP and for the Italy/UK LC tab. This is Italy GBP : This is UK GBP : This is what I'm…
-
Multiple "Detailed by" in Data view
Is it possible to use two ore more "detailed by" in an data view? It would like to report not only the average revenue / gross add per month by tarifcluster but by tarifcluster and a second or third entity.
-
How to autofit/autosize column width to width of object?
I have a simple dataview object where the size of the table itself is not as wide as the dataview object. Is there a configuration setting to autofit the column width/table width to the width of the data view objects?
-
Can you calculate with an entity?
Hi, you can display entities in a Dataview, but can you also calculate a new value with these entities in an algorithm, as you do with cube values? We want to multiply a cube value and an entity value within a Dataview. Is this possible in an algorithm? Kind regards
-
Hide specific rows
Hi BOARD Community, I'm trying to create a cube (which has the following dimension "SPV"; "Month"; "Item" and " Class"). The objective is to re-create the excel table attached below I would like to hide some combination (in rows) because i have to do combination on the exact Entities that i have in the screenshot. With…
-
Data View Configuration Options : zoom out, zoom in and change the scrollbar size
Hello, I’m looking for more configuration options in Dataview. Specifically, I’d like to increase the scrollbar size and explore the possibility of zooming out, similar to Excel, to view more columns in the table. If these options aren't available, is there any alternative? For exmple, could the Dataview be placed inside a…
-
Dynamic Data View Block Headings?
Hi, I would like to ask everyone: what options do we have when we wish for dynamic headers in our data views? My client is still in Board12, but we have a Board14 upgrade planned for the near future. Specific issue: the client would like to have a report that has dynamic headers with regards to months and versions. There…
-
Hide blank records when Data Blocks alignment is Vertical
Hi Board Team, Normally, we will use the FILTER to hide blank records. But once I changed the Data Block ALIGNMENT to vertically, the filter is not working any more. How can I hide blank records when Data Block alignment is vertical? Thanks My Axis properties are NOT selected as Show all. Thanks a lot
-
Selection of values in a block based on another block
I would like to offer the following functionality and wonder if achieving it in Board is possible. As per below table, for each line item the user would categorise the line item with an object Type in block b. This is a block of type entity where user selects the object type from the dropdown. Based on the selection made…