Transform Report Data

Transform the selected data

Select Transform data followed by Transform data.

Manage Parameters

Select Manage Parameters.

Create a filter parameter

Select New, followed by specifying a Name, Type and Current Value of the parameter you will use to filter data. In this example, the filter is based on the Instance GUID.

Test the filter you created

Select the down arrow on the column you’d like to filter, hover over Text Filters, and select the condition. For this example, select Equals as the condition to filter by InstanceGUID.

Filter the table based on your filter condition(s)

Select the down arrow followed by Parameter, and select the parameter you created, in this example, the InstanceGUID parameter. Then click OK.

Close the query to apply the filter

Select Close & Apply.

 

 

Updated on December 2, 2021

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support

Leave a Comment