nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OAS: Using SUM / RSUM In A Workbook Visualization

User_VMJII

Hello again!

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

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

+ I would also like to put this in the graph

Thank you!

Find more posts tagged with

Analytics

OAC

OAS

Accepted answers

Ram-Oracle

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

All comments

Ram-Oracle

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

User_VMJII

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

User_VMJII

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 ?