Dataview Layout: Impossible to apply a filter when an aggregation function is used
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
Answers
-
Hello Lucas,
please could you provide more information?
Which Board-Version are you using?
Could you provide a Screenshot of your Settings?0 -
Hi, We have the same problem
0 -
When you active the agregation function "Distinct Count" on a cube in the layout, the layout filter doesn't aply.
Sergio
0 -
0
-
In my case we are using B12.5.1
0 -
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
0 -
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
1 -
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
1 -
@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.
0
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP