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-08-2022

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.

 

  • Anonymous's avatar
    Anonymous
    08-08-2022

    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
    }
    }
    ]
    }