Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to Calculate :
Count(Name) where Sum(Meeting)={0}/Count(Name) grouping by Name
DB: Attached Excel data below
Script:
LOAD Name,
Only(Meeting) as Meeting,
Only(Age) as Age,
Only(JobLevel) as JobLevel,
Only(Salary) as Salary,
sum(Meeting) as Meeting1,
(month(Date)) as Month,
(year(Date)) as Year
FROM
/location of file/
group by Name,month(Date),year(Date)
Issue which I am facing is i want to do bifurcation with Month and Year. If i remove Month and Year from grouping then I am getting Sum(Meeting) properly else i am getting duplicates like:
Name , Month, Meeting1
Heena, Jan,0
Heena,Feb,1
How to get KPI where i can get "Count(Name) where Sum(Meeting1)=0 "
I am sure I am missing something in your request, but you could use set analysis to do your KPI request at the end:
count({<Meeting1={0}>}Name)
Please let me know if this is not what you were looking to achieve.