Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
KPI Scorecard Month-by-Month Date Range
Hello,
I have a saved search that displays all of my tasks completed (this year to date), and groups them by month with a second column showing the counts for each month (CUSTOM KPI #1). I have a second saved search that displays all of my tasks completed late (this year to date) and groups them by month, with a second column showing the counts for each month (CUSTOM KPI # 2).
I would like the KPI scorecard to aggregate the data ({CUSTOM2} / {CUSTOM1}) and display them on a month-by-month basis (Date Range): i.e.
JAN 95%
FEB 99%
MAR 94%
APR 100%
...
...
My issue is that regardless of the date range selected on KPI Scorecard, the dashboard will only divide the total of all tasks (this year to date) by the total of tasks completed late (this year to day). It doesn't appear to be able to perform calculations on the groups within the saved searches. How can I solve this? Is my issue with the saved search, or the KPI Scorecard?