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