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

How to get the ascending dates of activities in a report/analysis (not using Sort Ascending)?

Received Response
33
Views
1
Comments
Louisse Sunga
Louisse Sunga Rank 1 - Community Starter
edited Oct 16, 2025 3:38PM in Oracle Analytics Cloud and Server

Hi Everyone,

How can I get a list of the ascending dates for the activities available for one account using OTBI expression? Is it possible to get all the dates for the account in one row only?

Here is what I have so far:

CASE WHEN YEAR ("Activity". "Actual Start Date") = YEAR (CURRENT_DATE)
THEN
(CASE WHEN "Activity Extension". "Extension Attribute LOV 010" LIKE '%KPI%'
THEN "Activity". "Actual Start Date"
ELSE "Activity Extension". "Extension Attribute Timestamp 003"
END)
ELSE NULL END

Thank you!

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Welcome to the Oracle Analytics community and forum.

    I'm sure you have spent some time on that issue and therefore the question does make sense for you. But here nobody really knows exactly your situation and what you are trying to do.

    You have a formula returning a date, another thing that could maybe be a date or NULL. But it's difficult to translate that to your question: what do you mean by having a list of ascending dates? What dates are you talking about? What does the data looks like?

    Maybe you should post a sample dataset of what you are working with and what you expect to get as result instead.