Difference Count between current and previous status

[rfigueroa]

Hi,

In the example attached I need a second expression to get the difference between the COUNT of GrupoLink in current status and the COUNT for previous status.

For example for "DTU" status there is a count of 93, so I need a stacked second bar with the difference with "Terminada" status count which is 116.

As a demo I have added a third expression (green) with hardcoded values to show you the goal.

In the script I added a Prev_Estatus field, to point out to the previous status to try something like:

COUNT( {$ <Estatus = {$(=Prev_Estatus)} > } GrupoLink)

but didn't work

Thanks in advance for your help.

Roberto.

[Jason_Michaelides · Accepted solution]

Your first expression is =COUNT(DISTINCT GrupoLink)

Your second expression should be =Above(COUNT(DISTINCT GrupoLink)) - COUNT(DISTINCT GrupoLink)

See attached.

Hope this helps,

Jason

Message was edited by: Jason Michaelides - file attached!

[rfigueroa]

So simple
Thank you.