How to interpret FIXED fromTableau to Alteryx

[Madzy]

Hello,

I am trying to translate -->

{ FIXED [Date]:
IF [Phone Goal with Both] = "4" THEN [Number of Records]

else 0
END }

From Tableau to Alteryx and I am stuck on the FIXED function is there a way to do it for the Date column similar to the FIXED function in Alteryx? 

Thanks,

[BS_THE_ANALYST]

@Madzy I'm not sure what 'Fixed' does. Is it Grouping? If yes, you need to create a flag, then use a group by (which is like 'Fixed') and sum the flag column.

[JamesCharnley]

Hi @Madzy 

I find the easiest way to think of Fixed calcs is to think of it as 'For each'. To accomplish this as mentioned above, the best tool is the summarize tool, where we can evaluate each grouped date. I'm a little stumped by your calc because I would expect this to return an error in Tableau because your expression hasn't been aggregated, which it needs to be in the same way that you need to aggregate your measures in a summarize tool.