Oracle Fusion Data Intelligence

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

How to create a custom bin

Received Response
44
Views
2
Comments
Riti Malhotra
Riti Malhotra Rank 2 - Community Beginner
edited Aug 13, 2024 7:35PM in Oracle Fusion Data Intelligence

I am trying to create custom tenure bins and then counting how many locations fall under that bin. How do I accomplish this is in FAW. I used a case statement but the counts don't get placed in the correct bins.

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi Riti,

    Can you elaborate the details. Are you creating an visualization from any subject area or creating your own ?

    Regards,

    Arjun

  • Riti Malhotra
    Riti Malhotra Rank 2 - Community Beginner
    edited Nov 9, 2023 6:16PM

    from core HR.

    I am trying to show that Midwest (by year) has 6 locations that fell under 16-25% tenure bin; 2 that fell under 26 to 35% etc. I want to show this as bar chart with tenure bin at x axis and # of locations on the Y, '

    similar to 2nd screenshot but instead of multiple bars (location names) showing up under each bin - I want the bars to represent count of locations. when I add the count (locations code); the count doesn't get allocated to the appropriate bin.

    I used a case statement to create the bins.