Workiva Support Center

From Wdata, you can create queries based on data in Sustainability Program, including:

• Topics, metrics, values, and tasks
• Custom dimensions available for metric values
• Custom tags available for metrics

With these queries, you can:

• Explore your sustainability data through a focused lens, using filters and parameters.
• Connect the results to a Spreadsheet, such as to export sustainability data to a file or provide source links to reporting outputs.
• Provide additional context for metrics' tags or dimensions.

Add Program as a query source

To use a Program's data in a query:

1. From the query's Sources panel, click New source, and select the data to include in the results:
   
   
   • To include data about a Program and its topics, metrics, values, or tasks, select Sustainability, Sustainability program.
   • To include data about the custom dimensions available for a Program's metric values, select Sustainability, Program dimensions.
   • To include data about the custom tags available for a Program's metrics, select Sustainability, Program tags.

   Tip: For additional context around a Program's metrics' dimensions or tags, add the Program's data and its dimension or tag data as sources, and create a relationship to join them.

2. Search for and select the Program to use in the query, and click Add. 
   
3. From the Sources panel, specify how to use the data columns in the query:
   
   • To use columns as results in Builder, select them, and then select Add to fields or drag them to the Fields tab.
     
   • To use columns as filters in Builder, select them, and then select Add to filters or drag them to the Filters tab.
     
     For example, for a query with a Sustainability program source:

     Filter	Returns
     Program year	Only values collected for specific years
     Dimensions	Only metrics with specific custom dimensions applied, and the values collected for those dimensions
     Task status	Only tasks with specific data collection statuses

   • To include a column in the query's statement in SQL, right-click it and select Add to query.
     
4. Create the query as necessary.

Source columns

When you add Program data as a source, you can include its data columns in the query results.

Join Program data with dimension or tag data

For additional context around a Program's dimensions or tags, add the Program's data and its dimensions or tags as sources, and then create a relationship to join them.

For example, to include context around a Program's dimensions:

1. In Sources, select Sustainability program and Program dimensions, and choose the same Program for both.
2. In Fields, add the columns to include from each source.
   
   At a minimum, include:
   • Dimensions from the Program data
   • Value ID from the dimensions
3. In Relationships, add a left join:
   

   • In the left source, select Calculated field, then apply a calculation based on the Dimensions column from the Field Properties panel:

     JSON_FORMAT(JSON_ARRAY_GET(JSON_EXTRACT(JSON_PARSE( {1} ), '$.*'), 0))

     Tip: You can quickly add the JSON functions to the calculation from the Formula menu.

   • In the right source, select the Value ID field of the dimension.
4. Click Save.

Include columns for specific frameworks or tags

When you use a Program as a query source, you can include columns for all framework references and custom tags applied to its metrics. For clarity, you can apply calculations to include columns for only specific frameworks or tags instead.

Update Program query sources

As the Program evolves and introduces new features, you may need to update its query source to include any related columns.

Tip: When a Program has new columns to include, its query source displays a warning in Sources.

To update a Program's query source:

1. In Sources, right-click the source, and select Remove source.
   
2. Add the Program as a source again.
3. Edit the query to include the Program's columns as necessary.