Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Can we use group by when using Filter function?

Received Response
11
Views
2
Comments
ForSly
ForSly Rank 5 - Community Champion
edited Aug 13, 2024 5:26PM in Oracle Analytics Cloud and Server

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')

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics & AI Strategist

    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.

  • ForSly
    ForSly Rank 5 - Community Champion

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