is it possible to group in a saved search by week
# ask-stanley-ai
p
is it possible to group in a saved search by week
c
AI generated answer (using internal Slack threads):
Yes, it is possible to group data by week in a saved search in NetSuite. However, it might require some familiarity with SQL Case statements. Here's a general approach: 1. In your saved search, go to the Results tab. 2. Add a new line and select Formula (Text) as the summary type. 3. In the formula field, you can use a SQL Case statement to group your data by week. Unfortunately, the exact SQL Case statement to use will depend on your specific data and requirements, and it's not provided in the conversations. Alternatively, you can use SuiteAnalytics, which is a more advanced tool for creating reports and analyzing data in NetSuite. It allows you to create pivot charts and has many features that can help with grouping and summarizing data. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.846692622
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.818008721
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.816276848
Please provide your feedback on this answer.