Count the total number based on filter KPI

s.hasrio

Hi,

I have a Count line item of employees that has a formula of 1 in my employees module. I have a Total Count line item on another module to show the Total Count based on Filter that has a formula of:

my Filter formula is:

How do I show the total count of employee based on the filter?

Thanks

Lokesh_Madhu

@s.hasrio create another line item (dimension is based on your requirement ,if you want to show only count of all employees keep this line item dimension to none)to bring the sum of all employees

formula: count line item [select:employee:ALL]. Here count line item is the one you have created with the formula.

s.hasrio

Hello, @Lokesh_Madhu

I'm kinda confused. Can you elaborate?

Below are the modules and line items I am referring to.

Thanks.

Lokesh_Madhu

@s.hasrio I am assuming you have used user dimension in the both modules. In the Employee flat list , you need to have top level item.

after this write the formulas as

Hope this helps you.

s.hasrio

Hi @Lokesh_Madhu,

It doesn't work on my end

Dikshant

s.hasrio

@Dikshant Hi,

I tried yet it doesn't show anything on my card

Dikshant

Can you open the subsidiary view for Total Emp Count line item and check if there is any value there?

Dikshant

Also can you share what's the logic for SYS12 Filter?

Lokesh_Madhu

@s.hasrio

Please change the highlighted one to users and and bring then region flat,country flat etc to bottom .In this way Total employee count line item will not be subsidiary view and the data will be shown in the page.

s.hasrio

@Lokesh_Madhu it works! thank you so much for your help! the employee salary value doesn't appear on my card after the changes, so I just created a separate module for the count and salary.

thank you too @Dikshant! I appreciate the visual.