OAC-Derived Date column weekday display on Tooltip

Question

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,

Brendan T · Answer

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.