ServiceNow - Create a word cloud widget and PA dashboard

Creating a Word Cloud Widget - Technical Specifications

https://docs.servicenow.com/bundle/sandiego-now-intelligence/page/use/performance-analytics/task/create-word-cloud-widget.html

Pre-Requisites

First, ensure that an indicator (on the ‘pa_indicators’ table) exists, which you will use to base your widget data on. If not, then create a new one. Also, ensure that the ‘Indicator source’ field on the indicator record has a reference to an indicator source (on the ‘pa_cubes’ table). If not, then create a new one.

PA Text Index Configuration

Create a new PA text index configuration record by navigating to: Performance Analytics > Text Analytics > Setup and then click New to create a new record.

Populate field ‘Indicator source’ with the reference to the indicator source, as mentioned in the pre-requisites section above.

After that go to field ‘Fields to analyze’ and choose the fields that need to be analysed within the word cloud widget. Note: the fields to choose must only be of type text/string, such as: ‘Short description’ and ‘Description’. You can choose multiple fields.

Finally, ensure that field ‘Use system stop words’ is checked.

Using indicators on the PA Text Index Configuration

Once the PA Text Index Configuration record is created and saved, scroll down to the ‘Indicators’ related list on the new record and click the ‘Edit’ button, where you can choose one or more of the indicators that reference the indicator source specified in the referenced on the current form. Otherwise, create new one(s).

Once done, you will see a button on the PA Text Index Configuration form called: ‘Run historical collection’. Press it in order to collect historical data according to the specified indicator source.

Pressing this button will generate PA text indexes, which will appear under the ‘Performance Analytics Text Indexes’ related list, if any where to be indexed.

Navigate to: Performance Analytics à Widgets and click New to create a new widget.

Choose a name, and then select the main indicator, which relates to the chosen indicator source, after that set the ‘Type’ field to be ‘Text’ and then ensure that the ‘Visualization’ field is set to be ‘Word Cloud’. After that, scroll down to the ‘Display Settings’ tab and set the ‘Default field’ field to be one of the text/string fields that you want the widget to analyse.

Check if you need to modify any other fields, and then save the new widget.

Creating the dashboard

Now navigate to: Self-Service > Dashboards and click on ‘Create a dashboard’. Once you have specified the dashboard name and other setting, proceed to save it.

Once saved, scroll down the form and click on ‘View Dashboard’ related link. You will see the new dashboard with no widget added to it yet. Click the (+) plus icon on the top-right corner of the frame, and from the ‘Widget Category’ list select ‘Performance Analytics’, and then from the new list underneath choose ‘Text’. Now you should be able to see the new widget within the list. If not found, then you can type the widget’s name within the filter box. Once you select the widget, press the ’Add’ button.

Now you should have a successfully working word cloud widget as intended.