Jump to content

Taking last value in custom expression

Artis Pagsanjan

Recommended Posts


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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...