topic Re: I want The graph shows only Total < Target in App Development

I want The graph shows only Total < Target

Sxbbb — Fri, 15 Nov 2024 21:22:07 GMT

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?

Re: I want The graph shows only Total < Target

sbaro_bd — Mon, 02 Oct 2023 16:06:00 GMT

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.

Re: I want The graph shows only Total < Target

Sxbbb — Tue, 03 Oct 2023 02:01:03 GMT

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

Re: I want The graph shows only Total < Target

sbaro_bd — Tue, 03 Oct 2023 10:25:24 GMT

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.