6 Replies Latest reply: Aug 24, 2011 2:27 AM by sushil kumar

# how to calculate top 10 , top 20 defect count ??

Hi All,

I have four charts in a dashboard with same expression Sum (TOTAL_DEFECTS). Charts are "defect by operation", "defect by origin", "defect by time" and "defect by defect type".

i need to add a table/field to restrict the top 10 or top 20 or ALL defect for "defect by defect type" chart only. see the image below.

how would i achieve this functionality..

Thanks..

• ###### how to calculate top 10 , top 20 defect count ??

Hi,

What kind of chart it is..? Meaning is it a bar chart, straight table ..?

Regards,

Kaushik Solanki

• ###### how to calculate top 10 , top 20 defect count ??

it is a line chart with two dimentions see the screen shot below

• ###### how to calculate top 10 , top 20 defect count ??

HI,

Create a variable say vTop. Set it to 10.

Now create a input box for the same variable. Meaning here user will include the top 'n' value.

Go to properties of chart -> Sort -> click on the dimension and sort it by 'Y Value'.

-> Presentation -> at Max Visible No. type '=vTop'

Regards,

Kaushik Solanki

• ###### how to calculate top 10 , top 20 defect count ??

Thanks kaushik,

My 85 % problem is solved.. is it possible to provide only 3 options to user to select only TOP 10, TOP 20 or ALL.

In solution provide by you is good but user need to enter value and to select all defects user needs to enter *..

• ###### how to calculate top 10 , top 20 defect count ??

HI,

You can create a  inline table say like this.

Top:

Top Entry

TOP 10

TOP 20

ALL

];

Now at variable vTop set value as '

=if(GetFieldSelections(Top Entry) = 'TOP 10',10,

if(GetFieldSelections(Top Entry) = 'TOP 20',20,100));

Regards,

Kaushik Solanki

• ###### how to calculate top 10 , top 20 defect count ??

Thanks Kaushik