# How to Build NetSuite Dashboards and KPI Scorecards > Source: https://netray.co/erp-help/netsuite-how-to-dashboards-kpis > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer NetSuite dashboards are assembled from portlets (KPI, KPI Scorecard, List, Trend Graph, Report Snapshot) added via Personalize Dashboard, where KPI portlets show a single metric with a comparison period and KPI Scorecards show a table of multiple KPIs across time periods and can be published to a role for standardized reporting. ## Kind how-to ## System netsuite ## Erp Oracle NetSuite ## Module Dashboards / KPI Scorecards ## Query how to set up KPI scorecard on NetSuite dashboard ## Alternate Queries - NetSuite dashboard KPI meter configuration - how to add saved search to NetSuite dashboard - NetSuite KPI scorecard comparison periods - NetSuite dashboard portlets not showing data ## Applies To NetSuite Dashboards, all editions, role-based dashboard personalization ## Steps ### How to set up a KPI dashboard **Items:** Go to your Home or role dashboard, click Personalize Dashboard, and drag a KPI or KPI Scorecard portlet onto the page. On a KPI portlet, click the settings gear, choose the metric from the available KPI list (built-in metrics like Sales Total, or a saved search set up as a KPI), and set the comparison period (e.g. This Period vs Last Period, This Period vs Same Period Last Year). For a KPI Scorecard, click Set Up, add multiple KPIs as rows, and configure columns for different time periods (current period, prior period, variance) side by side in one portlet. To use a custom metric, first create a Saved Search under Lists > Search > Saved Searches, mark Available for KPI Scorecards / Reminders as needed, then select it as a KPI source in the portlet setup. For trend visualization, add a Trend Graph portlet and point it at the same KPI or saved search to chart the metric over time rather than a single snapshot number. Set thresholds and highlighting on KPI Scorecard rows (green/red coloring) under the KPI's threshold settings to flag when a metric crosses a target. To standardize a dashboard across a team, build it under an admin or designated role, then use Personalize Dashboard > Publish Dashboard (or Set as Dashboard for a role) to push the layout to all users of that role. If a portlet shows no data, check the underlying saved search's Public checkbox and audience/role sharing, since a KPI portlet inherits the saved search's own permissions. ## Sections ### KPI portlet vs KPI Scorecard vs Report Snapshot **Body:** A KPI portlet shows one number with a period-over-period comparison and percentage change, best for a single headline metric like total bookings or open support cases. A KPI Scorecard is a grid of many KPIs across multiple period columns in one compact portlet, the standard choice for an executive or sales manager view comparing several metrics at once. Report Snapshot portlets pull from NetSuite's financial reports (P&L, balance sheet trends) rather than saved searches, useful for finance-oriented dashboards that need report-level formatting and drill-down into the underlying report rather than a search result list. ### Building KPIs from saved searches **Body:** Any saved search with a single summary result (a count, sum, or single aggregated value) can become a KPI source. Create the search with the correct filters and a Sum or Count summary type on the results tab, then select it under the KPI portlet's Add/remove KPI dialog, where custom saved-search KPIs appear alongside NetSuite's built-in metrics. Comparison periods for a custom KPI require the search to be period-aware, typically by filtering on a relative date range like This Fiscal Quarter, so NetSuite can recompute the same search definition against the prior period automatically for the comparison column. ### Role-based dashboard publishing **Body:** Dashboards personalize per user by default, meaning a change one user makes does not affect others. To standardize reporting across a role (all Sales Reps see the same pipeline KPIs), an administrator configures the dashboard under that role's context and uses Set Dashboard as Standard for Role, which pushes the layout to users who have not customized their own. Users who previously personalized their own dashboard will not automatically get the standardized version unless the admin also resets their personalization, so a published dashboard update does not retroactively override every user's existing custom layout. ### Troubleshooting blank or slow portlets **Body:** A KPI or List portlet showing no data usually traces to the underlying saved search's audience/role sharing not including the viewing user, or a filter (such as a specific sales rep) that excludes the current user's own records when the search is not designed to be role-aware. Slow-loading dashboards are commonly caused by heavy saved searches with formula fields or joins across large transaction volumes running on every dashboard load; converting expensive summary logic into a scheduled script that writes to a lightweight custom record, then building the KPI off that record, avoids recalculating the heavy search on every page view. ## Pitfalls - Building a KPI off a saved search that is not shared with the roles who need to see the dashboard, resulting in blank portlets for everyone except the search's owner. - Using an absolute date filter (a fixed date range) instead of a relative date filter (This Period, Last Fiscal Quarter) on a KPI search, breaking the automatic period-over-period comparison. - Publishing a standardized dashboard expecting it to override every user's already-personalized dashboard, when existing personalizations are preserved unless explicitly reset. - Overloading a single dashboard with many heavy saved-search-driven portlets, slowing page load for every user of that role. - Forgetting that KPI Scorecard threshold coloring must be configured per KPI row; it does not inherit from the saved search's own conditional formatting. - Not testing a new KPI portlet under the actual target role (versus an admin role with full visibility), missing permission-driven blank results. ## Ai Angle ERPray, grounded on your NetSuite saved searches and dashboard configurations, can answer questions like which saved search feeds a specific KPI on the sales dashboard, why a portlet is blank for a particular role, and can draft the saved search definition for a new metric you describe in plain language, cutting out the trial-and-error of manually testing filter and summary settings in the search builder. ## Faq ### Can a KPI Scorecard mix built-in metrics and custom saved-search KPIs in one portlet? **Answer:** Yes. The Add/remove KPI dialog lists both NetSuite's built-in metrics and any of your saved searches marked available as a KPI source, and you can combine them as rows in the same scorecard. ### Why does my KPI show 0% change even though the numbers clearly differ? **Answer:** The comparison period setting may be misconfigured, or the underlying saved search uses an absolute date filter that returns the same static result regardless of which period NetSuite is trying to compare against, so it never recalculates for the prior period. ### Can I export a dashboard KPI to a report or spreadsheet? **Answer:** The KPI portlet itself does not export directly, but you can open the underlying saved search from the portlet and export its results to CSV, or add a Report Snapshot portlet where applicable for report-native export options. ### How do I restrict a dashboard KPI to only show a user's own records? **Answer:** Add a filter on the underlying saved search using a relative/dynamic value like Sales Rep is [current user] rather than a hardcoded employee, so the same saved search and KPI definition returns personalized results for each viewer. ## Search terms NetSuite dashboard setup, NetSuite KPI scorecard, NetSuite KPI portlet, NetSuite saved search KPI, NetSuite dashboard publish to role, NetSuite trend graph portlet, NetSuite dashboard blank portlet fix, NetSuite report snapshot portlet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json