How to create a custom bin

Riti Malhotra

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.

Mallikarjuna Kuppauru-Oracle

Hi Riti,

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

Regards,

Arjun

Riti Malhotra

Capture2.JPG

from core HR.

Capture.JPG

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.