---
sourceDocument: Brazil Platform Analytics
sourceDocumentLink: https://www.servicenow.com/docs/r/now-intelligence

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Service catalog variables in data visualizations

# Service catalog variables in data visualizations {#ariaid-title1}

Release version: Brazil  
Updated September 10, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read  
Group or filter data on visualizations by a variable on a selected service catalog item.

Reporting on variables can be helpful in determining if certain catalog items are useful on an instance, for example.

Additionally, you can create filters on the same variable. For example, if a specific mobile phone item has a storage variable, you can create a report that only shows those phones with 32 GB of storage.

## Use service catalog variables in data visualizations {#ariaid-title2}

When you create data visualizations based on service catalog data, stack and group the data by variables, use variables as columns in lists, and as columns and rows in multilevel pivot tables.

### Before you begin

* Users with a role other than viz_admin can use service catalog variables if an admin adds their role to the ACLs (access control lists) for the following tables: Options \[sc_item_option\], Variable Ownership \[sc_item_option_mtom\], and Variables \[item_option_new\].
* The data source for the visualization must be based on the Requested Items table \[sc_req_item\] or the Catalog Task table \[sc_task\]. Using other types of variables causes an error when generating the data visualization.
* The Oracle Database CLOB field can't retrieve the variables data in data visualizations. For a column string field of less than 4000 bytes, you can change the column type to varchar2. To compare the CLOB columns of a smaller size, use the to_char() function. For a larger size CLOB, get a substring for comparison using the dbms_lob.substr functions.

{#use-service-catalog-variables-dv__ul_ghl_fmt_5fb}

Role required: viz_creator or higher, including itil. To see the data, you need a role permitted by a report_view access control on the data source table.

### About this task

Note:  
Box and Trendbox visualizations can't use service catalog variables as a group by or alternative group by. Single Score, Calendar Report, and Geomap visualizations don't support grouping on any fields. Pivot Table visualizations can group by variables only as columns or rows.

### Procedure

1. Navigate to AllPlatform AnalyticsLibraryData Visualizations
2. Open the visualization to add the variable to.
3. Select one of the following options.

   | Option | Description |
   | Use the variable as a filter | Add or edit a data source and select Add custom conditions. If any custom conditions have already been defined, select + Add. Then select Variables at the bottom of the field list. |
   | Add the variable as a group by | Under Group by, select + Add. Then select Variables at the bottom of the field list. |
   | Add the variable as an alternative group by | Under Group by, select Add alternative group by. Then select Variables at the bottom of the field list. A viewer can select one of these variables at runtime, as described in [Select a group-by value in a data visualization as a viewer](https://www.servicenow.com/docs/H~28FOR0ipdvyN~RK7J2ZA "A viewer of a data visualization can select the value for grouping the data in the visualization."). |
   | Add the variable as a column or row in a pivot table | Under Group by, select +Add for Columns or Rows, then select Variables at the bottom of the field list. * If you create the report with the variable as the main Group By, the variable behaves as an inner join. * If you create the report with a regular field for primary grouping, and a secondary grouping on the variable, the variable works as an outer join. {#use-service-catalog-variables-dv__ul_qjb_tkz_25b} |
   |-|-|

   {#use-service-catalog-variables-dv__choicetable_p2g_2qf_v5}
4. Scroll to the end of the list of fields and select Variables.  
   The available variables appear. Not all variables that are available as group by values are also available as alternative group by values.
5. Select the variable you want.
6. If you're using the service catalog variable as a filter, select the operator and the value.
7. Select Apply.

### Variable as a filter {#use-service-catalog-variables-dv__example_lcp_qms_32c}

On the Edit data source page, no custom conditions are defined. Select Add custom condition.  

Scroll down the Select field list to Variable, select it, and select a variable. Use the Search box to limit the variable fields.  

Select the operator and the value, such as <kbd class="ph userinput">Is | A4</kbd>, and select Apply.

### Variable as a group by {#use-service-catalog-variables-dv__example_xcg_hvs_32c}

For a horizontal bar visualization of data in the Requested Items table, edit the group by in the Group by section. Scroll to the bottom of the list of fields and replace the Active field with Variables, and select your variable. Use the Search box to limit the variable fields.  

If you want to add a service catalog variable as a row or column on a Pivot Table, the steps are the same.

### Variable as an alternative group by {#use-service-catalog-variables-dv__example_nv2_gys_32c}

To add a different service catalog variable as an alternative group by, select Add alternative group by and scroll to the bottom. Expand Variables to see the available variables. Not all variables that are available as a group by are available as an alternative group by. Select the variables and then select Apply all.  

*[\>]: and then