Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
the table structure is like :
date | stage | status | amount | index
there are 7 processes and every process has 4 kinds of status (pass,fail,rework,scrapped). Now, I need to make a table like this:
the first pass = pass count / total
cumulative first pass = the current ratio of first pass * the previous ratio
These process are in order and the filed index means their sequence number.
Now I am using a plug-in called transpose table and I have successfully created all measurements except for the ratio of cumulative first pass, because I have no idea how I can get the ratio of first pass of the previous process.
Many thanks
1 Solution
Accepted Solutions
