Filter record set by selecting the metrics in a straight table

[#1]

Hi All,

I need to be able to apply a filter to a record set in a straight table chart so that only records that meet or exceed the requested criteria are displayed by the straight table.

For example, let’s say that the user wanted to review all products that had a “Defect Daily Percent” greater than 40%.  How can this be achieved?

Dimensions			Metrics
Date	Product	Defect	Defect Count	Defect Daily Total	Defect Daily Percent
1/1/2013	A	X	3	6	50.00%
1/1/2013	A	Y	2	6	33.33%
1/1/2013	A	Z	1	6	16.67%
1/2/2013	A	X	3	8	37.50%
1/2/2013	A	Y	2	8	25.00%
1/2/2013	A	Z	1	8	12.50%
1/2/2013	A	W	1	8	12.50%
1/2/2013	A	K	1	8	12.50%

I tried to create a calculated dimension using the Aggr function using the following syntax =Aggr(Sum(DefectCount) / Sum(Total <Date, Product>, DefectCount)), but it is not working. The calculated dimension displays a “1” for all calculated dimensions.

Also, the user would use a Slider to determine the threshold that needs to be reviewed.

Thanks for your assistance and support.

[Gysbert_Wassenaar · Accepted solution]

See attached example

[#3]

Wassenaar,

Thanks for the answers.  That's exactly what i was looking for.  I really appreciate you taking the time to help me solve this issue.