I want to chart what day of the week is my best sales day but I only have a date field. How would I determine what day of the week each day lands on?
In Starlifter you can create a calculate filed that uses either the function DayOfWeek or DayName.
DayOfWeek will return a number between 0-6 representing the day of week. 0 for Sunday and 6 for Saturday.
DayName will return value of the day of the week in a string value, either long or short.
For more info visit DayOfWeek