Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a table with fields as shown below (sample data).
I need to calculate the failure rate and display in the text box.
Failure Rate = (Number of distinct Label with Fail=1) / Number of distinct Label
In this example, Number of distinct Label with Fail=1 is 1 and Number of distinct Label is 2.
Please help with the expression for this.
I completed this using the below expression in the text box.
=Count(distinct{<Fail = {1}>}Label) & ' / ' &Count(distinct Label)
I completed this using the below expression in the text box.
=Count(distinct{<Fail = {1}>}Label) & ' / ' &Count(distinct Label)