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

OAS: Using SUM / RSUM In A Workbook Visualization

Accepted answer
55
Views
3
Comments
User_VMJII
User_VMJII Rank 4 - Community Specialist
edited Nov 18, 2024 8:50PM in Oracle Analytics Cloud and Server

Hello again!

In OAS DV I have a table (for one day) with time and values.

image.png

Is it possible for OAS to recalculate the sums for me from line to line like this?

image.png

+ I would also like to put this in the graph

Thank you!

Tagged:

Best Answer

  • Ram-Oracle
    Ram-Oracle Rank 6 - Analytics Lead
    edited Nov 5, 2024 10:10AM Answer ✓

    @User_VMJII ,Please create a new calculated column and use Rsum or running sum function like Rsum("measure name")

Answers

  • User_VMJII
    User_VMJII Rank 4 - Community Specialist

    @Ram-Oracle thank you very much for your quick reply!

  • User_VMJII
    User_VMJII Rank 4 - Community Specialist

    If I go further, I would like to check another option. I would like to add average data to the above data (RSUM) (eg the average of the last 30 days at certain times) - is this possible? My time information is written as 08/12/2024 12:00:00.000 AM. I tried the calculation:

    avg(case when TIME >= (CURRENT_DATE - 30/24) then X else null end),

    which is validated, but the result is not correct (the value is the same at all hours). I also played with the calculation:

    (case when TIME >= TIMESTAMPADD(SQL_TSI_HOUR, -720, CURRENT_DATE) then X else null end),

    but unfortunately it was unsuccessful. Do you have any other suggestions? Maybe @Ram-Oracle ?