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

Question

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!

Gianni Ceresa · Answer

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.