Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
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?