Sort by Option for Subject Area Date Column in DV

ALOK SH-Oracle

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

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

Any comment on this issue.