Solution: I used the RANK function to assign each address type a value of 1, 2, or 3. If a home address wasn’t available, the system automatically assigned the mailing address a rank of 1. Then I used the FILTER function to return only the entries with a rank of 1.

thanks I was able to rank them and then filter. appreciate your response.

I didn't find anything which is why I posted.. I am looking to only show Home address but it it doesn't exist then show Mailing address

thanks but I need it show only only 1 address even if two exist.

when I switch my classic version is a blank screen- Do I need to change the settings? Also if I create in classic version, will the chart show in the canvas? sorry am new to fusion analytics

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…

I understand its not available but is there a workaround available to display the information

How do you do the workaround.? i understand the bar chart and then add an overlay. we just recently got Oracle Fusion Analytics so any videos/reference material would be helfpul. thanks