Chart representation

[antupe]

I have this graph in which the red bar represents the new products that have arrived, the blue bar represents the pending units (this are the units that have arrived and must be repaired) and the green bar represents the number of units that have been repaired.

I have used he following expressions:

New products: count({$<DateType={'Arrived'}>} ProductID )

Repaired: count({$<DateType={'Repaired'}>} ProductID )

Pending Units: rangesum(above(total count({$<DateType={'Arrived'}>} ProductID ),0,RowNo(total)))-rangesum(above(total count({$<DateType={'Repaired'}>} ProductID ),0,RowNo(total)))

This is showing my data correctly but when I select a particular date, the formulas apparently apply from that date and not for the total of the data.

For example when the date 31/03/2022 is selected the representation changes from the one seen above to the following:

How can I avoid this?

[antupe · Accepted solution]

Not sure if there is a better solution, I went into Properties-->General-->Read Only