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

[sushil353]

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..

[kaushiknsolanki]

Hi,

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

Regards,

Kaushik Solanki

[sushil353]

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

[kaushiknsolanki]

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

[sushil353]

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 *..

[kaushiknsolanki · Accepted solution]

HI,

    You can create a  inline table say like this.

    Top:

     load * inline [

     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

[sushil353]

Thanks Kaushik