Oracle Fusion Data Intelligence

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

How to properly aggregate salary by Job Name for box plot visualization?

Accepted answer
31
Views
1
Comments
Caroline Blanchard
Caroline Blanchard Rank 6 - Analytics Lead

I'd love to create a visualization like above one in FAW using Salary and Job Name, something like the example shown above. I've run into an issue where the box plot simply shows all the salaries of a particular job summed together rather than the max median and minimum. Has anyone had success creating box plots in FAW, if so how should it be set up to see the ranges in the data?

Best Answer

  • Subha_Tripathy-Oracle
    Subha_Tripathy-Oracle Rank 6 - Analytics Lead
    Answer ✓

    Hi @CarolineAnderson ,

    Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.

    Looks like your issue is already reported as below bug.

    Bug 34134124 - TOOLTIPS IN THE BOXPLOT VIZ DOES NOT SHOW THE CORRECT "HIGH" AND "LOW" VALUE

    This bug is in closed status and the fix is expected in version 7.6.

    Thanks
    Subha