This article describes how the append dashboard filters as URL params to apply scope automatically to embedded dashboards.
If you already have dashboard filters defined, you can write the following command in your development console (Ctrl+Shift+I / F12 in Google Chrome ==> console tab) :
Type this line (this is encoding the parameters. Ignore the undefined comment you get):
var urlParams = encodeURIComponent(JSON.stringify(prism.activeDashboard.filters
Type 'urlParams' to get the result:
%7B%22jaql%22%3A%7B%22dim%22%3A%22%5Btable_name.field_name%5D%22%2C%22datatype%22%3A%22text%22%2C%22filter%22%3A%7B%22members%22%3A%5B%22first%20value%22%2C%22second%20value%22%5D%7D%7D%7D
Append to the end of your dashboard URL "?filter=" and paste the string you got
current_dashboard_url?filter=%7B%22jaql%22:%7B%22dim%22:%22%5Barea_wise_target.Region%5D%22,%22datatype%22:%22text%22,%22filter%22:%7B%22members%22:%5B%22North%22,%22West%22%5D%7D%7D%7D
Your dashboard will be opened with the values set as filters.
If you wish to define a new scope (instead of prism.activeDashboard.filters.$$items) then:
- Open the development console of your browser and type in:
var scope = [{
"jaql": {
"table": "Table_Name",
"column": "Field_Name",
"dim": "[Table_Name.Field_Name]",
"datatype": "text",
"merged": true,
"title": "Field_Name",
"collapsed": true,
"filter": {
"members":["First Value", "Second Value"],
"explicit": false,
"multiSelection": true}
}
}]
For multiple filters [an array of 2 or more jaql objects:]:
var scope = [{jaql:{
datatype:'text',
dim:"[Lead Generation.Country]",
filter:{members:["Portugal"]
}
}
},
{jaql:{
datatype:'text',
dim:"[Lead Generation.City]",
filter:{members:["Boston"]}
}
}
]
To use a date (time frame - this month):
"{
"dim":"[Lead Generation.Date (Calendar)]",
"datatype":"datetime",
"level":"months",
"filter":{"last":{"count":1,"offset":0}}
}"
or replace months with "days".
Other filter types
You can easily see the Jaql of the filter by going to "advanced" tab on the selected filter.
Please note that this is NOT a data-security feature and can be overridden easily by the user to view the entire data. To secure your data, please use the ElastiCube share option and data security permissions on the user/group level.
