How do we change the time period if we are using "Dashboard Filters (by Filter name)"? For example, I made separate date range buttons linked to dashboard date range filters such as “Last 90 Days,” “Last 30 Days,” “Last 7 Days,” "Last Month," "Last Quarter," and "Last Year".
In the BloX editor, I used code like this:
{
"style": "",
"script": "",
"showCarousel": true,
"body": [
{
"type": "Container",
"width": "50%",
"style": {
"margin": "0 auto",
"background-color": "#FFFFFF"
},
"items": [
{
"type": "ColumnSet",
"style": {
"display": "flex",
"flex-direction": "row",
"justify-content": "center",
"background-color": "#FFFFFF"
},
"columns": [
{
"type": "Column",
"width": "auto",
"style": "",
"items": [
{
"type": "ActionSet",
"actions": [
{
"title": "Last 1 Day",
"type": "Filters",
"data": {
"filters": [
{
"filterName": "Date Range",
"filterJaql": {
"selectedVal": "1",
"last": {
"offset": 1,
"count": 1
},
"multiSelection": true
}
}
]
}
},
{
"title": "Last 30 Day",
"type": "Filters",
"data": {
"filters": [
{
"filterName": "Date Range",
"filterJaql": {
"selectedVal": "2",
"last": {
"count": 30,
"offset": 1
},
"multiSelection": true
}
}
]
}
},
{
"title": "Last 90 Day",
"type": "Filters",
"data": {
"filters": [
{
"filterName": "Date Range",
"filterJaql": {
"selectedVal": "3",
"last": {
"count": 90,
"offset": 1
},
"multiSelection": true
}
}
]
}
},
{
"title": "Last Month",
"type": "Filters",
"data": {
"filters": [
{
"filterName": "Date Range",
"filterJaql": {
"selectedVal": "4",
"last": {
"count": 1,
"offset": 1
},
"multiSelection": true
}
}
]
}
},
{
"title": "Last Quarter",
"type": "Filters",
"data": {
"filters": [
{
"filterName": "Date Range",
"filterJaql": {
"selectedVal": "5",
"last": {
"count": 1,
"offset": 1
},
"multiSelection": true
}
}
]
}
},
{
"title": "Last Year",
"type": "Filters",
"data": {
"filters": [
{
"filterName": "Date Range",
"filterJaql": {
"selectedVal": "6",
"last": {
"count": 1,
"offset": 1
},
"multiSelection": true
}
}
]
}
}
]
}
]
}
]
}
]
}
]
}
It is not changing the 'level' such as days, months, quarters, or years. Instead, it is only changing the count and offset value of the filter. So, I added script-level code and gave each button 'selectedVal', and in the script editor, I used code like this:
// Preserve Blox filter inputs after filter change, sync with current filter state
widget.on('ready', function () {
// Only hide the title for viewers of the dashboard
if (prism.user.roleName == 'consumer'){
$('widget-header', element.parent()).css('display','none');
}
// Modify to match the relevant filter title
let filterModifiedName = "Date Range"
filterModifiedName = filterModifiedName.toLowerCase()
// Variable containing the Dashboard filter modified by Blox
let modifiedFilter = widget.dashboard.filters.$$items.find(function (filterItem) {
return !filterItem.isCascading && filterItem.jaql && filterItem.jaql.title && filterItem.jaql.title.toLowerCase() === filterModifiedName;
});
// If relevant filter has from and to values selected (change as needed if filter uses members or any other type of filter)
if (modifiedFilter && modifiedFilter.jaql && modifiedFilter.jaql.filter && modifiedFilter.jaql.filter.radiotVal) {
// Filter from and to value from dashboard filters
let selectedVal = modifiedFilter.jaql.filter.radiotVal;
console.log(selectedVal);
if(selectedVal === "1") {
modifiedFilter.jaql.level = "days"
}
if(selectedVal === "2") {
modifiedFilter.jaql.level = "days"
}
if(selectedVal === "3") {
modifiedFilter.jaql.level = "days"
}
if(selectedVal === "4") {
modifiedFilter.jaql.level= "months"
}
if(selectedVal === "5") {
modifiedFilter.jaql.level = "quarters"
}
if(selectedVal === "6") {
modifiedFilter.jaql.level = "years"
}
// Change filter ID selector as needed, to match ID parameter of input Elements
let inputElementOffset = $('[id="data.filters[0].filterJaql.selectedVal"]', element)[0]
// Set value of inputs to value of filter
inputElementOffset.value = selectedVal
}
})
It actually changes the time period (e.g., 'level': 'month'), but it's not working as expected. Is there any better solution for this other than "Dashboard Filters (by Dimensions)"?
Regards
Muznah
2 ACCEPTED SOLUTIONS
