How to add days instead of number on charts


Im having trouble changing the days from numbers to actual days. Currently the days are listed as 1,2,3,4,5,6,7 but I want to change those to the actual Monday, Tuesday, Wednesday, etc..
I used the code doc[''].value.getDayOfWeek()but always get the number instead of the actual days.

Should I change the code- or use an entirely different code?


You can use a Static Lookup formatter.

  • Go to Management > Index Patterns.
  • Press the edit icon on the field that you wish to format.
  • Choose the "Static Lookup" format and add options that map your numeric values to string.
  • After saving (and maybe refreshing), the field will display the string values across all applications.