Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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!
So simple
Thank you.