Dataview Layout: Impossible to apply a filter when an aggregation function is used

Lucas Charello
Lucas Charello Active Partner, Community Captain
25 Likes 10 Comments 25 Up Votes November Badge of the Month
edited May 2023 in Platform

Hello community, I'm quite new here. if this is not the right place for this question, please redirect me.

I have a Dataview layout in which I use an aggregation function to display the average value for my block along the time entity "Month".

When I try to apply a filter to this layout, it has no effect. However, when I remove the aggregation function, the filter is applied normally. I also tested this using an the "Distinct Count" aggregation and the result is the same. I could figure out a workaround and calculate the average by using a Nexel (and adding many block), but I'd like to know if this situation has a simplier solution.


Is somebody familiar with this situation?

Thank you for the help.

Lucas CHARELLO

Tagged:

Answers

  • Nico Gerbrand
    Nico Gerbrand Employee
    Third Anniversary 100 Up Votes 10 Comments Level 100: Foundations of Building in Board

    Hello Lucas,

    please could you provide more information?

    Which Board-Version are you using?
    Could you provide a Screenshot of your Settings?

  • slopez@micanalytics.com
    slopez@micanalytics.com Active Partner
    First Anniversary First Comment

    Hi, We have the same problem

  • slopez@micanalytics.com
    slopez@micanalytics.com Active Partner
    First Anniversary First Comment

    When you active the agregation function "Distinct Count" on a cube in the layout, the layout filter doesn't aply.

    Sergio

  • slopez@micanalytics.com
    slopez@micanalytics.com Active Partner
    First Anniversary First Comment
    image.png

  • slopez@micanalytics.com
    slopez@micanalytics.com Active Partner
    First Anniversary First Comment

    In my case we are using B12.5.1

    image.png

  • Daniel Trajanovski
    Daniel Trajanovski Active Partner
    Second Anniversary Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board First Comment

    Hello Nico,

    I am having the same issue, do you have any tips? I'm working on the 12.5.1.1.85250 version

    Thank you,

    Daniel

  • Tommaso Riva
    Tommaso Riva Employee
    Fourth Anniversary 25 Likes 5 Answers 10 Comments
    edited August 2023

    Hi All,

    the weird behavior seems to be a bug.

    The filter option should not be affected by the aggregation function.

    For the time being, the workaround is to shift the filter to the layout level in the screen selection (selection based on cube).

    Please be kind and open a ticket to our support for further investigation.

    Thank you,

    Tommaso

  • Nicola De Beni
    Nicola De Beni Active Partner
    Fourth Anniversary 25 Up Votes Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board

    Hi Tommaso,

    we opened the ticket but Support told us that this is a known limitation.

    Would be possibile to update the manual in order to share this not so known limitation with the entire community?

    Thanks

    Nicola

  • Holly Rieke
    Holly Rieke Employee
    100 Likes Second Anniversary 10 Comments New Community Member
    admin

    @Nicola De Beni Thank you for your comment here in Community! I have shared your feedback about this known limitation with the appropriate resources. They will review it for consideration to add to the existing Known Limitations list.

Categories