cancel
Showing results for 
Search instead for 
Did you mean: 

Dashboard Filter Date in Last 180 days or NULL?

mirzay
7 - Data Storage
7 - Data Storage

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 using the Advanced formula below and some variations of this but getting the Invalid Syntax or Invalid Query messages:

{
"explicit": true,
"multiSelection": true,
"members": [
"N\\A",
{
"last": {
"count": 180,
"offset": 0
}
}
]
}

3 REPLIES 3

PriyankaDolli
Sisense Team Member
Sisense Team Member

Hi Mirzay,
Try this instead:

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

Thank you for the response Priyanka. I am not getting the expected result.
(Converted to Months instead of days but tried both ways)
I am expecting the range to be last 6 months to end of next month.  What I get are these dates.
mirzay_0-1659978023777.png

 

PriyankaDolli
Sisense Team Member
Sisense Team Member

You can use this script to get the range to be last 6 months to the end of next month:

{
"or": [
{
"last": {
"count": 6,
"offset": 0
}
},
{
"next": {
"count": 1,
"offset": 1
}
}
]
}