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

LAST_PERIOD function

Question
3
Views
0
Comments
user12045713
user12045713 Rank 1 - Community Starter
edited Aug 13, 2024 3:39PM in Oracle Analytics Cloud and Server

Hello,

Did someone successfully used LAST_PERIOD function?

I need to use that but there is no diffrence in physical query if compare it to query with LAST function. No difrence in results. "Data is dense" flag is checked.

I need that becouse LAST returns the last non-null value, whereas LAST_PERIOD returns the last value, regardless of whether it is null.

It is hard to find any information about this function.

pastedImage_1.png

Thanks,

N.