Forum Discussion

ZebraMK's avatar
ZebraMK
New Member
5 years ago
Solved

Dynamic Rolled First Pass Yield (RFPY) graph

Hi all,

 

I am trying to add a graph to my report where I can display RFPY in a dynamic way.

 

I only have 1 table with all details, I have a column for Prime_total, Prime_Pass and the Prime_fail. (how many units we tested in total and how many passed or failed)

We also have a column called "dashboard" and a column for "Process".

Processes are subsets of the dashboard.

Example:

Dashboard A contains

Process ABC

 

Dashboard B contains

Process DEF

 

Dashboard C contains

Process AEC 

 

Using these fields I have created a measure that calculates the first pass yield; 

FPY = DIVIDE(SUM('mqsprod global_dashboard'[PRIME_PASS]),SUM('mqsprod global_dashboard'[PRIME_TOTAL]),BLANK())

 

The tricky part now is to calculate rolling first pass yield, the calculation is simple per process you calculate Yield, and multiply it with the next process.

RFPY is: 90% x 90% x 90% x 90% x 90% = 59%.

 

What I want my users to do is to select a dashboard using a slicer.

This will give them the correct processes to multiply yield by.

 

But how can I get this realized?

Need Help
Tutorial Requests
  • ZebraMK's avatar
    ZebraMK
    5 years ago

    We have resolved this problem by using:


    RFTY = PRODUCTX(KEEPFILTERS(VALUES('mqsprod global_dashboard'[PROCESS])), CALCULATE([FPY]))

3 Replies

  • ZebraMK's avatar
    ZebraMK
    New Member
    5 years ago

    We have resolved this problem by using:


    RFTY = PRODUCTX(KEEPFILTERS(VALUES('mqsprod global_dashboard'[PROCESS])), CALCULATE([FPY]))
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi ZebraMK ，

      It's glad to hear that your problem has been resolved. And thanks for sharing your solution, it will help others in the community if they face the similar problem with you. Could you please mark your last post as Answered since it has been resolved? Thank you.

      Best Regards

      Rena

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi ZebraMK ,

    Could you please provide some sample data of table 'mqsprod global_dashboard' (exclude sensitive data)and the expected result with examples? Also could you please explain the calculation logic of RFPY? Is this a cumulative multiplication? How to determine the number of multipliers?

    The tricky part now is to calculate rolling first pass yield, the calculation is simple per process you calculate Yield, and multiply it with the next process.

    RFPY is: 90% x 90% x 90% x 90% x 90% = 59%.

    Best Regards
    Community Support Team _ Rena Ruan
    If this post helps, then please consider Accept it as the solution to help the other members find it more.