Is it possible to sort the dates and and show the ...
# generalc
c c
06/08/2021, 12:41 PMIs it possible to sort the dates and and show the date instead of a numeric number?
k
Kristy Kapsner
06/08/2021, 12:49 PMYou can create a text formula field and map the date using the MMM-YY type masks.
Kristy Kapsner
06/08/2021, 12:49 PMYYYY-MM works well for sorting
c
c c
06/08/2021, 12:52 PMHow do i create a formula field?
m
MySuite
06/08/2021, 2:16 PMYou don't need a formula field
MySuite
06/08/2021, 2:16 PMYou can create a formula in SuiteAnalytics Workbook
MySuite
06/08/2021, 2:17 PMYou open the dataset and create a formula. Use SQL To_char to grab the month name from a date field
k
Kristy Kapsner
06/08/2021, 2:18 PMExactly what I meant if I didn't communicate well. The only problem with MON mask is that it will sort alphabetically.
👍 1
3 Views