Top, Mid, and Bottom Clients in Waterfall Chart

Efraim

Hello,

Is there a way to show the Top N clients, all clients in the middle, and Bottom N clients in a Waterfall chart?
I can either show Top N or Bottom N clients but not both at the same time and also I am still missing the Mid-range

Helmut Heimann

Hi @Efraim ,

there currently is no native way to achieve that.
You'd have to precalculate the top/flop customers and use those values in the waterfall.

But the precalculation would have to be done each time the user changes the selection criteria on the screen, the top/flop need to be dynamic.

Best,
Helmut

Efraim

Thanks @Helmut Heimann !
For the precalculation, am I correct to assume it is to be done using Procedures?

Helmut Heimann

https://community.board.com/discussion/comment/19500#Comment_19500

yes, @Efraim , that's correct—you need to precalculate the cubes by procedure.