Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAC-Derived Date column weekday display on Tooltip

Received Response
17
Views
1
Comments
Hasan Sd
Hasan Sd Rank 5 - Community Champion
in Oracle Analytics Forum

Hello…As shown in below screenshot of a simple bar chart showing Products sold and revenue .We are required to display Weekday(Sunday.Monday,etc) data on the tooltip .However Tooltip section only allows measure data .Kindly advise how to implement this. The requirements are also mentioned below :

1)Displaying Weekday on tooltip .

2)When single date is selected in filter it should display related Weekday on tooltip and when multiple dates are selected in filter it should display :Weekday :Multiple Weekdays.

Thank you,

image.png

Answers

  • Brendan T
    Brendan T Rank 6 - Analytics & AI Lead

    To implement a tooltip that displays specific weekday logic, you can use the calculated data elements combined with the Custom Tooltip feature. Because the tooltip section often requires measures, the workaround is to convert your text attribute using an aggregation function like MIN or MAX.