Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE Dashboard Gauge not displaying decimals for custom formulas. Any work-around?

Received Response
32
Views
5
Comments
image237
image237 Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

I have made a custom formula that calculate SPI(t) (an Earned Schedule metric) values. I selected the Dial Gauge to display it in OBIEE. But the dial gauge only displays in whole numbers. But the same gauge is able to display decimals when it is displaying values of default SPI. I Have tried adjusting the settings without any success. Is there a solution to this?

Answers

  • RVohra
    RVohra Rank 7 - Analytics & AI Coach

    I cannot recall, please check if there is an option to change the Data Type to Double.

  • Chere-Oracle
    Chere-Oracle Rank 6 - Analytics & AI Lead

    Hi image237,

    Do other views display decimal for SPI(t), such as table or pivot table veiws? If not, what formula are you using for SPI(t)?

  • Wayne Van Sluys
    Wayne Van Sluys Mod

    What does your formula look like?

  • Wayne Van Sluys
    Wayne Van Sluys Mod

    try multiplying by 1.0

  • Chere-Oracle
    Chere-Oracle Rank 6 - Analytics & AI Lead

    If all parts of your formula are Integers, you will get an Integer value. To fix in this case, multiply the left-most value by 1.0 — this will ensure the whole formula. If you put the 1.0 multiplier at the end, it may not work as intended.