How to calculate Totals and Top5 totals in single stacked bar chart expression

[grakeshqvd]

Hi, 

We need to calculate Count of Totals and Count of Top5 totals in single stacked bar chart(Set Analysis).

Calculate Count of "EmployeeName"where the "EmployeeIssues" not equals to 'FAIL' and 'NULL'.

Need to write the expression for both - Total and Top5 total count in single bar chart.

Regards,

Rakesh

[kaushiknsolanki]

Hi,

Can you share sample data along with expected output.

Regards,

Kaushik Solanki

[grakeshqvd]

HI Kaushik,

Please find sample data. For EmployeeName-AAA, need to calcualte EmployeeName"where the "EmployeeIssues" not equals to 'FAIL' and 'NULL'. Like the way same for other Employess also. 

Expected Output:

We need to show in the stacked Combo chart Month wise,

Where Totals and Top5 Totals bars  for each month.

Totals(Bar):  EmployeeName"where the "EmployeeIssues" not equals to 'FAIL' and 'NULL'.

Top5 Totals(Bar): only Take Top5 totals from Totals

Top 5% Totals(Line): Top5 Totals/Totals.

Thanks,

Rakesh

Regards,

Rakesh

[kaushiknsolanki]

Hi,

On what basis you want to find the Top.

Also do you want to just count distinct employee or you want to count the transactions with filter condition i.e (Not equal to Null or Fail)?

Regards,

Kaushik Solanki

[grakeshqvd]

Need totals for Month wise.

No distinct, 

want to count the transactions with filter condition i.e (Not equal to Null or Fail).

Regards,

Rakesh