dataview algorithm block: how to set summary mode to 'no total'?

Arnaud Villemain

Hello,

I am wondering how to hide the total value in a dataview for a block of type algorithm.

This is actually possible for a block of type cube:

but i don't see it for a block of type algorithm:

1. Do i oversee some options in the block settings within the layout window ?
2. as a workaround, i play with foreground and background colors outside of the layout (in block format

, set foreground color to transparent for Totals and Grand Totals

) to hide the totals, but 👎️it doesn't do anything, my grand total has still a black foreground color for block b….

🤷‍♂️

• Why is the transparency on foreground color not working here?
• Is it a known issue?
• How do other users solve this?
• should i create a new idea in the community which suggests to add the "no total" summary for algorithm blocks?

Thanks and regards

—

Board Version 14.4

Edward

Hi Arnaud, I've never found a good solution to this problem however what I can recommend is you add the entity that is your row to the layout, you then modify your algorithm to check the entity block:

IF(ENTITY>1, 0, original algorithm)

then set your summary total to calculated

This will mean that on all your rows the entity count will show 1 and on the total row it will show total count of entity under that group.

It's not perfect but it works (unless you have a lot of quick layout usage)