Date Dimension Issue

[rustyfishbones]

Hi,

I have the following chart, and I want the date to display the first letter of the day of the date, so I want M,T,W,T,F etc......

I could create it in the script, but I want to create it as a calculated dimension. Can you help

[sunny_talwar · Accepted solution]

May be using Dual function

Dual(Left(WeekDay(Date), 1), Date)

[rustyfishbones]

Thank You Sunny!