Hagar Ahmed
08/31/2024, 2:47 PMCeligo AI
08/31/2024, 2:47 PMAI generated answer (using internal Slack threads):To show the month in names and not in the format
2024-06
in a saved search, you can use a formula field in your saved search.
Here are the steps to do it:
1. Go to your saved search and click on the Results
subtab.
2. Click on New Field
and select Formula (Text)
as the type.
3. In the Formula
field, enter the following formula: TO_CHAR({trandate}, 'Month')
. This formula will convert the date into the month name.
4. In the Summary Type
, select Group
.
5. In the Label
field, enter a name for this field, for example, Month Name
.
6. Click Save
.
Now, when you run the saved search, you will see the month names instead of the date format 2024-06
.
Please note that this solution assumes that you are using the trandate
field in your saved search. If you are using a different date field, replace {trandate}
with your date field in the formula.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
08/31/2024, 2:47 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.85025239
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.839523
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.839277327
Celigo AI
08/31/2024, 2:47 PM