Apply Filters on widgets present in different layers

AIVHUB application allows its users to apply filters on widgets that are present across different layers and tabs.

In this example, we will apply filter on the table widget displaying sales of products in first layer and the pie chart depicting the percentage of sale of products based on line of products in the second layer which we had created in the previous chapter.(To know in detail about filters, visit Filters section of the training manuals).

In order to learn how to create multiple layers, visit the previous chapter by clicking on Create Layers of this section.

In order to apply filters widgets accross different layers follow the steps below:-

  1. As seen in the previous session, our first layer contains a table widget shown in the figure below:-



  2. Similarly, we had created the following pie chart displaying line of products in the second layer.



  3. Now we will apply filters on the table in the first layer and pie chart in the second layer as follows:-
  4. In order to do so, Click on Component from the list of component in the dashboard, a configuration box would open as follows:



  5. Go to All Filters tab as shown in the above figure and Click on to add new filter. This tab displays all the existing filters and enables the user to add new filters.
  6. This will open the following dialog box:-



  7. Here we have created a filter named Products to filter the data of product sales based on the line of products.
  8. Click on button in order to save a filter which will appear on your screen under the All Filters tab as follows:-



  9. Now go to the Filter Widgets tab to link filter with dataset.



  10. For this example, select Display Type as Multi Select from the dropdown as shown in the figure above.
  11. Select the Sales Data.ds dataset from the drop down menu of Datasets, select Column Name and Column Value as productLine from the dropdown and Default Value as Vintage Cars as shown in the figure below:-



  12. Finally in order to link filters to widgets go to the Link Filters and Widgets tab as follows:-



  13. As seen in the figure, select layer1, tab1 and Product Sales Data from the dropdown as shown in the figure above.
  14. In the similar manner apply filter on the chart in the second layer as follows:-



  15. Finally, go to the Filter View to apply Filter as follows:-



  16. Finally, click on the button which filters the values for the selected countries as follows:-



  17. You can check the output by going to layer two by clicking on the topmost icon which will open a dropdown as follows:-



  18. The chart in the second layer will be displayed as follows:-



  19. The user can also add a layer widget in order to check the changes reflected on both the widgets simultaneously
  20. Click on the Component icon from the top right corner menu, a list of the available component will open up as follows:



  21. Click on Component from the list of the component into the dashboard, a configuration box would open as follows:



  22. Provide name as shown in the figure and select layer2 from the dropdown menu.

  23. Now the user can click on any cell in table to reflect changes in the chart or vice versa.



In the similar manner, the user can dynamically link widgets spread accross multiple tabs in different layers of the AIV dashboard.