In a saved search, for results summary label, can ...
# suiteanalyticsn
NW88
10/27/2020, 4:13 AMIn a saved search, for results summary label, can you add formula's to display current month, next month, etc?
d
David B
10/27/2020, 4:15 AMThere's a SA for that
David B
10/27/2020, 4:15 AMDavid B
10/27/2020, 4:17 AMalthough you can use various formula, I personally use the MONTHS_BETWEEN Function
n
NW88
10/27/2020, 4:23 AMHi @David B, thanks for this, I actually was fine bringing in values in each column by month, I more meant the summary label itself, since I am the month of each column will actually change as I am looking forward 3 months for sales forward dated. So column 1 label this month would be Nov, but next month column 1 would be Dec.
d
David B
10/27/2020, 4:24 AMah okay, I don't think you can do dynamic values for column header labels
n
NW88
10/27/2020, 4:25 AM@David B boo. We are keying off of a different date field for future ship date, otherwise I would just use a sales order report. I might need to start looking at the new analytics books.
NW88
10/27/2020, 4:26 AMThanks anyways.
13 Views