This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
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
