I want The graph shows only Total < Target

[Sxbbb]

I have Chart :

I have  field :  'Target'

I have  expressions   'Total' : Sum( Aggr(if ((INPUT ) >0 ,INPUT , [INTERNAL) - (if(Time(MAX_Finish)= Time_FinishMachine , WorkOrder , '0' )),ID,Start,Shift,Group)*SQFT) 

I want The graph shows only Total < Target. What do I have to do?

[sbaro_bd]

Hi,

The Show option work with boolean values : 1 for TRUE and 0 for FALSE. The expression  looks like :
IF(<your_condition>,1,0).

Regards.

[Sxbbb]

I Try

 if( Sum( Aggr(if ((INPUT ) >0 ,INPUT , [INTERNAL) - (if(Time(MAX_Finish)= Time_FinishMachine , WorkOrder , '0' )),ID,Start,Shift,Group)*SQFT) )
<[Target ],1,0) 

The chart doesn't show  

TRUE and  FALSE doesn't show  

[sbaro_bd]

The issue from your condition expression. You make a comparaison between an aggregate value (calculation) with a non-aggregate value (field).

Add a MIN()/MAX() or ONLY() function on Target (i'm supposing that target is an unique value) and see if it work.

Regards.