Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to calculate Count of flag but count expression is invalid
Calc_Temp:
Load
Year,
Name,
Role,
Group,
"Domain/Department",
QuestionGroup,
Weightage,
Questions,
Ques_Calc,
Rating as Rating_Raw,
1 as Flag,
Count(Flag)
Resident RawData
Group By Year,Name,QuestionGroup;
@mnvrma and ?
Data:
Load
Year,
Name,
Role,
Group,
"Domain/Department",
QuestionGroup,
Weightage,
Questions,
Ques_Calc,
Rating as Rating_Raw,
1 as Flag
Resident RawData
left join load Year,Name,QuestionGroup, Count(Flag) as count_Flag resident Data Group By Year,Name,QuestionGroup;
@mnvrma and ?
Data:
Load
Year,
Name,
Role,
Group,
"Domain/Department",
QuestionGroup,
Weightage,
Questions,
Ques_Calc,
Rating as Rating_Raw,
1 as Flag
Resident RawData
left join load Year,Name,QuestionGroup, Count(Flag) as count_Flag resident Data Group By Year,Name,QuestionGroup;
Hello Sir @Taoufiq_Zarra
Can you please go through this post as I am facing little challenge in requirement
Link: Calculate Rolling Sales according to Max Date available for each Shop