Table Event
1. Create a new dashboard and give name Summary of the dashboard.
2. The Edit menu box appears as you click on Table Widget icon. And a widget gets added in content place automatically in dashboard.
3. Enter Following details in General Property.
Dataset: sales.ds
Select all the field in Dataset Columns.
4. Fill above details as shown in figure below:
5. Go to advance tab and drag and drop Country and Product line column in row.
6. Click on save and exit to save the changes.
7. Create a filter and give named country as shown in figure below:
8. Click on setting icon of the filter and fill the details in filter Widget:
Source: Dataset
Dataset: Sales.Ds
Column Name: country
9. Fill above details, As shown in figure below:
10. Click on Link Filter and Widgets Option and enter the details as below:
Layer: Layer1
Tabs: Tab 1
Widget: Table Widget 1
11. Fill above details, As shown in figure below:
12. Click on Filter view property and click on + icon of the country.
13. Click on Save and Exit.
14. Fill above widgets, as shown in figure below:
15. Create a New Dashboard and give name Detailed of the dashboard.
16. The Edit menu box appears as you click on Pie chart. And a widget gets added in content place automatically in dashboard.
17. Enter Following details in Chart Property.
Dataset: sales.ds
Category Axis: country
Value Column: Order Number
Aggregation: Sum
Select all the field in Dataset Columns.
Fill above details as shown in figure below:
18. Click on Preview and Save and Exit.
19. Add one table widget in the Detail dashboard.
20. The Edit menu box appears as you click on Table Widget icon. And a widget gets added in content place automatically in dashboard.
21. Enter Following details in General Property.
Dataset: sales.ds
Select all the field in Dataset Columns.
22. Fill above details as shown in figure below:
23. Add two filter country and productline in the dashboard, As shown in figure below:
24. Click on setting icon of the country filter.
25. Enter the following details in Filter widget.
Source: Dataset
Dataset: sales
Column Name: country
26. Fill above details, As shown in figure below:
27. Click on Link filter and widget option.
28. Enter the following details in Filter widget.
Layer: Layer1
Tab: Tab1
Widget: Chart Widget, Table widget
-Both widget link with country column.
29. Click on setting icon of the productline filter.
30. Enter the following details in Filter widget.
Source: Dataset
Dataset: sales
Column Name: productline
31. Click on Link filter and widget option.
32. Enter the following details in Filter widget.
Layer: Layer1
Tab: Tab1
Widget: Chart Widget, Table widget
Both widget link with productline column.
33. Click on Filter view property and click on + icon of the country & productline.
34. Click on Save and Exit.
35. Fill above widgets, As shown in figure below:
36. Click on embed icon of the detailed dashboard and copy the external embed link.
37. Now, go to the summary Dashboard.
38. Edit Table widget and go to event section and write below script:
39. Click on save and exit button to save changes.
40. Go to preview and apply country filter on table.
41. Click on any product line. Let's say click on Trains. As soon as you click on Trains, it will open detail dashboard in new tab and data of detail tab is filtered by product line clicked and filter value.
