1

I need to fetch the value of last 24 hours in my output. i am using mongo data source. can anyone demonstrate

{
	"collection": "nad_stats",
	"query": {
		"INSERT_DATE": {
			"$gt": {
				"$humanTime": "06/24/20"
			}
		}
	}
}

this query is not working in my case

2 
{
	"collection": "nad_stats",
	"query": {
		"INSERT_DATE": {
			"$gt": {
				"$humanTime": "24 hours ago"
			}
		}
	}
}
3

image

it is not working . i dont know the issue. i didn’t get any output and didn’t get any error.

My db screenshot below-:
image

4

Try setting it to 48 hours ago. It’s possible the conversion between UTC excludes those records. For example, as I write it is 18:08 UTC on June 25th. 24 hours ago would be 18:08 on June 24th. But your date records don’t include a time stamp, so Redash treats them as June 24th at 00:00:00, which is more than 24 hours ago.