Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
=If(RowNo() >1 , your_expression)
1)You will have to change the dimension and not expression for that.
for example:
if(Date([Start Days],'DD/MM/YYYY')>'01/12/2013',CLASS)
2)Or lese if you have RowNo then
=if(RowNo()>1,Expression)
Thanks,
It not working can you suggest other ways.
Ashif
Can you please attach the qvw?
I can post the all data.
CLASS | Equipment | Start Date | End Date | MTTF(Days) |
Chis-Transit Mxr 6 | 993 | 23/02/2014 | 23/02/2014 | 131 |
Chis-Transit Mxr 6 | 993 | 14/05/2014 | 28/05/2014 | 80 |
Chis-Transit Mxr 6 | 994 | 20/10/2013 | 25/10/2013 | 5 |
Chis-Transit Mxr 6 | 994 | 20/10/2013 | 25/10/2013 | 22 |
Chis-Transit Mxr 6 | 994 | 28/10/2013 | 29/10/2013 | 3 |
Chis-Transit Mxr 6 | 994 | 27/11/2013 | 28/11/2013 | 29 |
Chis-Transit Mxr 6 | 994 | 20/01/2014 | 21/01/2014 | 53 |
Chis-Transit Mxr 6 | 995 | 25/11/2013 | 25/11/2013 | 62 |
Chis-Transit Mxr 6 | 997 | 01/12/2013 | 02/12/2013 | 104 |
Chis-Transit Mxr 6 | 997 | 20/01/2014 | 21/01/2014 | 49 |
Chis-Transit Mxr 6 | 997 | 05/03/2014 | 07/03/2014 | 43 |
Chis-Transit Mxr 6 | 1018 | 23/10/2013 | 26/10/2013 | 11 |
Chis-Transit Mxr 6 | 1018 | 29/11/2013 | 02/12/2013 | 34 |
Chis-Transit Mxr 6 | 1385 | 27/10/2013 | 28/10/2013 | 1 |
Chis-Transit Mxr 6 | 1385 | 27/10/2013 | 28/10/2013 | 866 |
Chis-Transit Mxr 6 | 1385 | 10/04/2014 | 10/04/2014 | 164 |
Chis-Transit Mxr 6 | 7773 | 06/10/2013 | 06/10/2013 | 12 |
Chis-Transit Mxr 6 | 7773 | 18/10/2013 | 18/10/2013 | 12 |
Chis-Transit Mxr 6 | 7773 | 20/10/2013 | 20/10/2013 | 2 |
Chis-Transit Mxr 6 | 7773 | 22/10/2013 | 22/10/2013 | 2 |
Chis-Transit Mxr 6 | 7773 | 01/11/2013 | 01/11/2013 | 10 |
Chis-Transit Mxr 6 | 7773 | 08/04/2014 | 08/04/2014 | 158 |
Chis-Transit Mxr 6 | 9129 | 06/10/2013 | 06/10/2013 | 499 |
Chis-Transit Mxr 6 | 9129 | 16/11/2013 | 29/11/2013 | 67 |
Chis-Transit Mxr 6 | 9129 | 08/02/2014 | 09/02/2014 | 71 |
Hi this will surely help you
HI Saumya
I think we're wrongly interpret the problem. I don't just want first record to remove from just first row of table but for each equipment.
Regards
Ashif
there is a way to do that also
How?