Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I need to display count the data that arer out of the limits in the selected time period, i have this:
control chart
table
i have the expression to know wich ones are out of range:
if( ([S/F] > vLSGralTAD) or ( [S/F] < vLIGralTAD), [S/F],0)
Where i expect how many data are out, in and calculate de percentage of those who are inside de bounds.
Out: 6
In: 16
Total: 22
% In: 72.7 %
Any one can help me to this set expression syntax.
Following is the expression I'm using for count the data where it is not showing any error in expression view but no data returned.
For count the data that are in the limits:
Count( {<if( [S/F] > vLSGralTAD or [S/F] < vLIGralTAD),0,1)>} DISTINCT{<fecha_ex={"<=$(vFechaFinal)>=$(vFechaInicial)"} >} )
someone who can support me?