Count invalid Expression

[mnvrma]

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;

[Taoufiq_Zarra · Accepted solution]

@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;

[Jeet_007]

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