resort columns

Louise Just

Hi,

I have a dataview with weeks in the columns.  Currently Board displays the oldest week first through to the most recent week, reading left to right across the page.  How can I get Board to display the most recent week first through to the oldest week, reading left to right across the page.  Thanks.

Helmut Heimann

Hi, Louise Just,

 

there currently exists no option of sorting the columns the way you'd like.

But, there is the possibility to use a "pointer"--meaning an additional entity with members like

Current week, last week, last week-1, ... last week-n 

Those members have to be mapped to the "real" weeks using a mapping cube dimensioned by week (BOARD time entity) and your "pointer" entity, having 1 for the current combination, 0 otherwise. This has to be administered every week to keep it up to date.

The "pointer" will then have to be set as y-axis instead of BOARD's standard time dimension.

 

Hope, this helps.

 

Kind Regards,

Helmut

Pietro Ferrari

Hi, 

alternatively you could also try the following: instead of setting the Week By Column in your Layout, set nothing there and use multiple the cube with the offset time function. 

For example, set in the data columns of your Layout

(a) Sales

(b) Sales, with Offset = -1 

(b) Sales, with Offset = -2

(c) Sales, with Offset = -3 

… and so on for as many periods you want to see.

In this case you will need to select one week only, the current week, which will be displayed in the first column (a), then the second column will be current-1, then current-2 and so on. 

 

This approach is convenient if you want to create a rolling report with a fixed number of weeks, like "last 6 weeks rolling" and you avoid having to create a new entity manage relationships and all that derives from this.

If you have many different cubes that you want to display in your report, this approach is a little tedious to configure since you can't use the entity "By Column" then you have to include each cube as many times the number of rolling periods (will take you a little to configure but does the job without changes to the datamodel).

 

Best, 

Pietro

Samuele Marchetto

Hi Pietro Ferrari,

it's could be a nice solution if only we could have the capability to dynamically set the heading of the block with value of the week. For example, if week 04-2019 is selected, the second block with offset -1 should view the heading 03-2019 (using for example a formula like "@Week-1")

Bye

Louise Just

Hi marcsamu,

I agree with you, I had already thought of Pietro's solution but can't implement till I can work out how to dynamically display the week each column is referencing.  Will update this post if I find a way.  I was hoping there might have been some other solutions to my problem our there in Boardville land.

Louise

Etienne CAUSSE

Hi Louise Just

I would recommend the following:

1. Create a customized time entity called "Reverse week"

2. Load a relationship between week and Reverse week as below:

• Week 1 -> Week 53
• Week 2 -> Week 52
• ...
• Week 53 -> Week 01

 

Then you can just split your dataview using Reverse week as column instead of Week, and you're done.

 

Note you can still manage your selections by Week and not by reverse week (which might be confusing).

You can keep the correct week number in your "reverse week" description and order by reverse week code.

 

The advantage compared to Pietro Ferrari's solution is that you don't need to define the number of columns in advance.

 

Etienne

Louise Just

Thanks Etienne, this is a great suggestion I hadn't thought of.  Will try your suggestion.