Artis Pagsanjan Posted June 9, 2020 Share Posted June 9, 2020 Hi, Im trying to build a simple pareto bar chart with soft_bin count. However, I need to take the last soft_bin from a duplicate record (of a column named DEVICE). Just taking the soft_bin column as is (per attached image) produces inaccurate count as both before & after soft_bins are accounted; I just need the last (after) soft_bin. Im trying to apply below expression for the bin but it is getting rejected: Last[soft_bin] over [DEVICE] Any suggestion how to implement such Link to comment Share on other sites More sharing options...
Artis Pagsanjan Posted June 10, 2020 Author Share Posted June 10, 2020 I tried to use below expression in the Y-axis (Fail Qty). No error but I am still getting a double count for the same device with 2 soft_bin. I just want to take the last soft_bin for duplicate device. Appreciate any inputs/suggestions how to overcome this. count(Last([soft_bin]) OVER (Intersect([device],[rework_flag]))) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now