Filter on Multiple Values Selections though Query prompt and List Builder Component

This is most frequently requirement from business that they want to change data in Chart or other dashboard component based on user selections. For this, selector components like Filter, Combo box and list view etc. can be used. Also they want to select multiple values in selection and according to multiple values data must be updated from database

To provide multiple values selection, below component can be used.

1. Query prompt selector component
2. List Builder component

Business Scenario:

We have Sales data which contain Dealers, Month and sales Plan Quantity and Actual Sales Quantity, User has to select a dealer or multiple dealers based on that Month wise sales data must be updated and shows in Column Chart.

1. Using Query Prompt Selector Component:

Step 1: Create a query and make ‘In List optional prompt’ on dealers as per below screen shot.

Step 2: Bind query data with chart component as below.

Step 3: Now we need to add Filter on dealers, just drag and drop ‘Prompt’ into canvas. Check ‘collapse’ property in Display Option.

Step 4: Execute the report and select multiple values and single values and click on refresh button, Query data gets refresh/update as per selections in query prompt selector.

    2. Using List Builder Component:

Step 1: Create a query and make ‘In List optional prompt’ on dealers as per below screen shot.

Step 2: Bind query data with chart component as below.

Step 3: Now we need to add Filter on dealers, Drag and drop List Builder component on canvas and bind dealer’s data with Labels property and Destination property to give input to prompt. Refer below screen shot.

Step 4: Drag the Query Refresh Button and check ‘Refresh Queries property’ to refresh Query Data.

Step 5: Execute the report and select multiple values and single values and click on ‘Refresh Query’ button, Query data gets refresh/update as per selections in query prompt selector.