Use case: You have one summary level of Dashboard which contains summarized data. You don’t want to show detail data in this dashboard. Also, you have another dashboard which contains Detail level of data which is called Detailed dashboard. Now if you want to see detail data of summarized data and by clicking on summarized data it should redirect to the detail dashboard you have created with filter value applied on summary dashboard.

-In this document we will see how to meet this use case. So, we have one summary level of dashboard and one detail level of dashboard. Summary level dashboard contains column chart showing aggregated data, filter widget which filter country and detail dashboard have table widget showing detailed data of that column chart, filter widget filtering country column.

1. Click on hamburger icon.

2. Click on dashboard tab and open Column Chart in edit mode for the Summary Dashboard.

3. The Edit menu box appears as you click on Column chart icon. And a widget gets added in content place automatically in dashboard.

4. Enter Following details in Column Chart Widget:
Dataset: salesb.ds
Category Axis: country
Value Column: quantityOrdered
Aggregation: sum

5. Fill above details in edit box, As shown in figure Below:

6. Click on Preview and Save and Exit.

7. Create a New filter.

8. Give the Name country, As shown in figure Below:

9. Click on Save.

10. Click on Setting icon in Filter.

11. Enter Following details in Filter:
Filter Name: country
Display Name: country
Event: On click

12. Enter Following details in Filter Widget:
Source: Dataset
Dataset: Salesb.ds
Column Name: Country
Font Size: 12
Toggle Save Filter and set Default when Clear.

13. Click on Link Filter and Widget Property.

14. Enter Following details in Link Filter and Widget Property:
Layer: Layer 1
Tabs: Event Check
Widget: Table Widget 1
Select the country in Available Column.

15. Fill above details as shown in Figure Below:

16. Click on Save and Exit.

17. Create a New Dashboard and Give Name Embed Link of the Dashboard.

18. From Right Vertical Menu Click on the Table Widget icon in Embed Link Dashboard.

19. The Edit menu box appears as you click on Table Widget icon. And a widget gets added in content place automatically in dashboard, As shown in Figure below:

20. Enter Following details in General Property:
Dataset: salesb.ds
In Dataset Column select all the Field.

21. Create a New filter.

22. Give the Name country, As shown in figure Below:

23. Click on Save.

24. Click on Setting icon in Filter.

25. Enter Following details in Filter Widget:
Source: Dataset
Dataset: Salesb.ds
Column Name: Country
Font Size: 12
Toggle Save Filter and set Default when Clear.

26. Click on Link Filter and Widget Property.

27. Enter Following details in Link Filter and Widget Property.
Layer: Layer 1
Tabs: Event Check
Widget: Table Widget 1
Select the country in Available Column.

28. Fill above details as shown in Figure Below:

29. Click on Save and Exit.

30. Click on Embed icon of the Embed Dashboard, As shown in Figure Below:

31. Copy the Link of Internal Embed in Embed.

32. Click on Cancel.

33. Open the Summary Dashboard in Edit mode.

34. Click on Setting icon on the Chart Widget.

35. Enter following details in Extra Label.
Toggle Enable Extra Label
Label Text: Detailed Data
http://localhost:8080/aiv/embed/internal/aivHubInternalEmbed/a_i__206&a_n__EmbedLink&a_as__dashboards&a_af__false/country___{{country}} (link Copy from [detail] Embed Dashboard)

[ Link Description: Here after “&a_af__false/” parameter you will see “country___” is there. This is filter name that we have created in detail dashboard. To pass summary dashboard filter value in to detail dashboard filter we need to provide summary dashboard filter name in curly brackets for ex. Filter name is “country” in summary dashboard so at the end we need to add {{country}} as you can see in above link.

-this will take present filter value from summary dashboard and pass this value to detail dashboard filter when clicked on detail data link

-also change “&a_af__false/” to “&a_af__true/” to filter out data when detail dashboard loaded.

NOTE: here filter name is case sensitive. You have to apply same name as filter name]

36. Fill above details in edit box, As shown in figure Below:

37. Click on Save and Exit.

38. In Summary Dashboard filter select the country Germany and click on Filter, As shown in figure Below:

39. Now Click on the Detailed Data in Summary Dashboard.

40. It will redirect the page in Embed Dashboard

41. It will show you Germany Data, As shown in Figure Below: