Pivot Event
This document contains information on a feature of Pivot Event. In AIV, the user can redirect
from one Tab to another
Tab in same Dashboard using Script in Pivot widget.
In this Scenario we are using two Tab in one dashboard. In first tab we are using Scripting
in Pivot widget and second
Tab contain Table widget and Filter. Link this filter with Table widget. So, when you click
on USA in pivot it will
redirect on event tab and filter USA value and pass it to Table widget.
1. From Right Vertical Menu Select the Pivot Widget icon.
2. The Edit menu box appears as you click on Pivot widget icon. And a widget gets added in content place automatically in dashboard.
3. Enter following details in chart controls:
Name: Product Count Data
Dataset: Sales.ds
Drag and drop country in rows, month in Columns and priceEach in Values.
4. In value click on Setting Icon and enter Following Details.
Name: price
Display Name: price
Type: Sum
5. Click on setting icon of country and select Script.
6. Enter following code in script:
Code Explanation:
1. var a= '{ {country} }' : storing value of country when clicked in a variable a. Here { {country} } denotes name of the column from which we are fetching data on click. User can define column name as per requirement in this code.
2. console.log(a) : getting clicked data in console for verification.
3. var tab = new customEvent("aiv-change-tab", { "detail": 1 } ); window.parent.dispatchEvent(tab);
-This is an tab change event used to change tabs with scripting. "detail": 1 [Here 1 is the index of a tab where we want to switch on click of country].
The first tab has index 0 and 2nd tab has index of 1 and so on. User can define index as per their use case.
4. setTimeout(function() { var filter = new CustomEvent("aiv-filter-call", { "detail":{"country" : a} } ); window.parent.dispatchEvent(filter); } );
-This code used to trigger a filter event where "detail":{"country" : a} , country is filter name we have created in second tab. And a is variable which has country data stored.
In value dropdown select country.
7. Click on Preview and save and Exit.
8. Now, match your pivot chart with the below example, it should look like the figure below:
9. Create another Tab and give name Event.
10. From Right Vertical Menu Select the Table Widget icon.
11. The Edit menu box appears as you click on Table Widget. And a widget gets added in content place automatically in dashboard.
12. Enter following details in General property:
Dataset: sales.Ds
In the Dataset Columns select the header checkbox.
13. Create a filter and enter following details in filter.
Name: country
Event: On Change
14. Enter following details in Filter widgets:
Source: Dataset
Dataset: sales.ds
Column name: country
15. Enter following details in link filter and widgets:
Layer: Layer1
Tab: Event
Widgets: Pivot Widget 1
Select country
16. Click on save and Exit button.
17. Now, match your Table chart with the below example, it should look like the figure below:
18. Now, click on USA in pivot it will redirect on event tab and filter USA value and pass it to Table widget.
