Top 5 Filter in Chart (Board 10.1.2.)

Unknown
Unknown
edited April 2020 in Platform

Hi Boardville,

 

I have some problems with a Chart I would like to create.

 

The chart should display costs by project and week.

image

I have data of around 50 projects but I only want the top 5 to be displayed.

 

Therefore I tried to use the Layout Filter:
imageimage

 

Now my problem is that Board uses the filter on the X Axis which are my weeks and changes the sorting here:

image

However, I just want the projects to be filtered.

 

Any idea how I can get this done?

Thanks

 

Mathias

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers

    Hi Mathias Flintrop,

     

    could you please let us know the definition of you block "Project" you want to use for sorting? Your chart is using the dimension "Projects Prod". I would assume your block "Project" is an entity - is that set to display the projects' code or description? 

    Board sorts depending on a value, so your "sorting block" should represent different values.

     

    Kind Regards,

    Helmut

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers

    Hi Matthias,

     

    as for a DV the filtering/Keep top is done on the "by Row" Entity and not the by Column one. So you need to swithc both in layout and use the "switch row/col" setting of the Chart Object

     

    Regards

    Björn

  • Unknown
    Unknown

    Hi Björn,

    I missed to say that I want to use this graph in the web version.

    If I recall correctly the "Switch row/col" is not supported but I'll give it a try.

  • Unknown
    Unknown
    edited March 2020

    Hi Helmut Heimann,

     

    sorry for explaining not detailed enough.

     

    I basically want to do the following:

     

    I have a cube which contains cost of different projects per week, the costs are allocated to the Entity: "Project" and "Week":

     

    Example:

    image

    So I have multiple projects but I just want the Top 5 beeing displayed:

    image

    In this example I filtered by the latest week but I am also fine if the Top 5 is chosen by total expenses.

     

    Finally I want this to be shown in a graph, which can be displayed in the web:

    image

     

    I can get this done in the client:

    image

    Using Switch Row/Column as Björn Reuber mentioned, but in the web I get an error:

    image

     

    Is this fixed in Board 11?

     

    Thanks for your help and have a nice weekend.

     

    Best

     

    Mathias

  • Florian Lübbing
    Florian Lübbing Active Partner
    Second Anniversary First Comment
    edited March 2020

    Hi Mathias,

     

    as far as I experienced, "switch Row/Column" isn´t available yet. Neither in 10.3  and follwing 10.x versions

    nor in the current BOARD 11 version.

     

    I am also awaiting it urgently

    Best regards

     

    Edit: I just found this topic: Switch row/column  - it might work, I think I got confused with the "is inverse" option that isn´t working yet...

     

    image

Categories