Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

Is it possible to create dynamic Percentage of Spend Category Filter based on selected attribute?

Received Response
31
Views
5
Comments
JobDeLuna
JobDeLuna Rank 5 - Community Champion
edited Aug 13, 2024 7:30PM in Oracle Fusion Data Intelligence

Hello,

I am planning to create a filter of percentage of spend bucket such as:

Top 20%, Top 21-50%, Top 51-80%, Top 81-100%

Is it possible to create dynamic Percentage of Spend Category Filter based on selected attribute?

For example, I have selected Division as parameter, then the filter for the Percentage of Spend Category will adjust based on Division.

I am aiming to have something like this:

So the spend and the # of parts result per % bucket will adjust based on the 'Parts Analysis View' selected

pa.png


Tagged:

Answers

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

    Hi @JobDeLuna

    Did you tried the Key metric calculation at workbook creation level .?

    Regards,

    Arjun

  • JobDeLuna
    JobDeLuna Rank 5 - Community Champion

    Hello @Mallikarjuna Kuppauru-Oracle . Thanks for your response.

    I am aiming to have something like this:

    So the spend and the # of parts result per % bucket will adjust based on the 'Parts Analysis View' selected

    pa.png


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

    Hi @JobDeLuna

    This is sort of pivot table with setup of KPI metrics , i hope you can able to do the same using dv workbooks or any classic report.

    Regards,

    Arjun

  • JobDeLuna
    JobDeLuna Rank 5 - Community Champion

    Hi, @Mallikarjuna Kuppauru-Oracle my problem is how to set up the percentage bucket

  • Edwin_Martinez
    Edwin_Martinez Rank 3 - Community Apprentice

    Hi @JobDeLuna,

    I hope this helps, but I find it the best way possible is to create custom filter calculations for each one of the buckets.

    This is example of one that I did for 61-90 day Quick Quits.

    CAST(FILTER("HCM - Workforce Core"."Facts - Workforce Events"."Hire Count" USING (TIMESTAMPDIFF(SQL_TSI_DAY, "HCM - Workforce Core"."Employment Information"."Work Relationship Start Date","HCM - Workforce Core"."Employment Information"."Termination Date")BETWEEN 61 AND 90))AS FLOAT)/"HCM - Workforce Core"."Facts - Workforce Events"."Hire Count"