Is it possible to setup a KPI that compares 'last week' to the same 'last week' in the last fiscal year?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that setting up a KPI that compares 'last week' to the same 'last week' in the last fiscal year directly might not be possible using the standard KPI Scorecard UI in NetSuite. The options provided in the UI for date range comparison are typically 'Year to Date', 'Last Fiscal Year', 'Two Fiscal Years Ago', etc. However, you might be able to achieve this by creating a custom KPI using a saved search. The saved search can be designed to pull data for 'last week' and the same 'last week' in the last fiscal year. Once the saved search is created, you can add it to your KPI Scorecard. Here's a general idea of how you might set up the saved search: 1. Define your criteria to include the date range for 'last week' and the same 'last week' in the last fiscal year. You can use formulas to dynamically calculate these date ranges based on the current date. 2. Define your results to include the sales data (or other data) that you want to compare. 3. Save the search and add it to your KPI Scorecard. Please note that this is a general approach and the exact steps may vary based on your specific requirements and NetSuite setup. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******