Remove first selected value in chart expression

[#1]

Dear Experts

Help me removing first row in chart flat table  and chart expression. Need to remove MTTF 104 from chart table.

Following expression is used to obtain below result.

=ceil(fabs(sum({<Plant={$(vWERKS)}>}if(Date(EQM_AUSVN,'M/D/YYYY') >=v_YTM_MONTH and Date(EQM_AUSVN,'D/M/YYYY')<=(v_FTM_DATE),MTBF ))

/Count({<Plant={$(vWERKS)}>}if(Date(EQM_AUSVN,'D/M/YYYY') >=v_YTM_MONTH and Date(EQM_AUSVN,'D/M/YYYY')<=(v_FTM_DATE),if(EQM_MSAUS='X',EQM_QMNUM)))))

Thanks

Ashif

[tresesco · Accepted solution]

Front-end? Try expression like:

If(Above(total Equipment)=Equipment,[MTTF(Days)])

The similar could be done in script as well.

Note: here sort order and aggregation matter.

PFA

[Anonymous]

Hi Ashif,

I managed to get a table working using the following expression

=Sum(Aggr(If(IsNull(Above(Sum(MTTF))),0,Sum(MTTF)),Equipment, Date))

Then ignoring zero values in my chart. Not sure if this is what you are looking for and it will probably need more development but it might help you.