Chart of averages

The method I use to get the weekday from a date is as follows:

  • Firstly, I create a column that contains the names of the days of the week (Sun, Mon, Tue, etc). This column can be in any table (I usually have it in a Lookup/Helper table)
  • Then I use the following Math formula on my Date column: Weekday(Date)-1
    – This returns an integer between 0 and 6, representing the day number of the week, beginning with Sunday == 0
  • I then use a Single Value column to fetch the Day name from my list of days, using N from start, where N is the result of the math column.

A simpler option is to use the Format Date plugin, however that plugin is known to give inconsistent results with Safari on IOS, so I don’t use it for that reason.

2 Likes