Skip to Main Content

Oracle Analytics Cloud

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Transform datetime field to use in graphic prompt as month (example: 2023 / 03)

Bruno FerreiraMar 7 2023

Hi.

I need a way to convert a datetime field like the ootb Month(Time) field to output as 2023 / 03 for example.

I want to use this field as graphic prompt so it filters the results within the selected month.

It must not repeat itself in the prompt.

I've tried using the ootb Month Time field but it does not filter the results correctly if I use a custom datetime field in the horizontal line of the graphic.

Sometimes it display results from other months.

Thank you

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked by Renae Stout-Oracle on Jul 8 2024
Added on Mar 7 2023
0 comments
209 views