Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Can you share sample data along with expected output.
Regards,
Kaushik Solanki
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
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
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