add "no total" summary option for dataview algorithm block
- What is your idea?
To add the ability to hide the total and grand total value for an algorithm block in a dataview.
This ability doesn't exist actually (Board version 14.4):
- What specific problem are you trying to find a solution to, or what new scenario would this idea respond to?
There are KPIs which are calculated in dataviews using block algorithm whose total or grand total row doesn't make sense on a business perspective, even using the available summary options (average, count, calculated…). It can be calculated percentages for example.
I wish it would be possible to hide the total and grand total rows, as it is already possible for ALL other (Cube, Entity, Ranking, Rule) block types.
- What workaround have you found and used so far (if any)?
If there is an entity set by Row in the dataview's axes → set this entity also as a block (assume block b) → create an algorithm block c with this formel: if(len(b)>1, a, 0) (assuming the numeric data is in block a) → set summary mode to calculated.
So two blocks more to hide total row in block b…
See this message: https://community.board.com/discussion/comment/21229?utm_source=community-share#Comment_21229
Comments
There are no comments yet