Forum Discussion

mirzay's avatar
mirzay
Cloud Apps
08-04-2022

Dashboard Filter Date in Last 180 days or NULL?

I need to create a dashboard filter that will filter the Closed Date In Last 180 days OR if Closed Date is NULL Would you know how to include the OR Condition in a Dashboard Filter? I tried usin...
dashboards & reporting
Anonymous's avatar
Anonymous
08-08-2022

Hi Mirzay,
Try this instead:

{
"or": [
{
"last": {
"count": 180,
"offset": 0
},
"custom": true
},
{
"include": {
"members": [
null
]
}
}
]
}

mirzay's avatar
mirzay
Cloud Apps
08-26-2022

I am using your filter formula to filter for a date that is Null or the date occurred in the last year. The result is picking up all years and also the null value. How can I restrict to filter to last year and null values?


{
"or": [
{
"last": {
"count": 1,
"offset": 1
},
"custom": true
},
{
"include": {
"members": [
null
]
}
}
]
}