Count based on value of previous record

Ask a Question

Hello,

I'm currious if it would be possible to have somehow a summary indicating how many times (accross all modifications) the red background in the image (chart) appears.

The logic for making the background red is as follows:

Some example (based on the image above) of what I would like to see...

A small table:

Modification|#RedBackgroudns

FirstModif|0

NextModif|0

NextModif|1

NextModif|0

NextModif|3

NextModif|0

...

-----------------

Total: 14 (cfr. image)

I've attached a simplified version of the use-case above.

Any help is welcome!

Thanks in advance!

Greetz,

Maarten

0 Replies