Sort by Option for Subject Area Date Column in DV

ALOK SH-Oracle · Jun 19, 2023 6:59AM

Hi Expert,

Sort by Option for Date Column which is coming from Subject Area in DV is not coming as Sort option.

But when Date column is coming from Dataset is having that option to sort by different type.

Do we have any option without touch the RPD we can do it by using DV feature.

ALOK SH-Oracle · Aug 14, 2023 6:26AM

I found one solution were this scenario can be achieved.

First Create Month Year Column by using below Logic :

MONTHNAME("Date") || ' ' || CAST(YEAR("Date") AS CHAR)

Create one Numeric column called DateSort for Sorting in Graph.

min(EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER ( 30 ),Date", 'YYYYMM'))

Go to any Graph then under sort option choose custom and then DateSort column.

ALOK SH-Oracle · Jul 6, 2023 9:04AM

Any comment on this issue.

Oracle Analytics Cloud and Server