When creating an Insight, I usually add some filters. Imagine that I want to use a property of type Date as a filter but I want to map it to Day of the Week (e.g. Monday, Tuesday, etc). Essentially, creating a custom event property that maps a Date to Day of the week. How can I do it? I couldn't find any formula that converts Date to Day of the week. Plus, in the Breakdown this mapping can be done very easily, meaning that there is a Mixpanel internal mapping function but is not available as a formula function.
