Can we use group by when using Filter function?

Question

I have this two metrics that I am adding together but i also wanted to group the results set by employee ID, however i cant figure out how to use the group by with my filter function. any suggestions?

FILTER("Fact - Ap"."#  Applicants" USING ( "Details"."Active Flg"  = '1'  )+

FILTER("Fact - "."# of Applications" USING ("Details"." Name" IN ('Passed Application Review')

ForSly · Answer

How can I use the BIN logic to achieve my results?

Robert Angel · Answer

Hi,

not with filter, no, but you can filter filter results, or you could use SUM by with a case statement to achieve a similar result.

Or you could use Bin logic.

So there are a number of ways.