query purchaseOrderDetails($startTime: timestamptz, $endTime: timestamptz) {
purchaseOrder_purchaseOrder_aggregate(
where: { markedCompletedTime: { _is_null: false }, created_at: { _gte: $startTime, _lte: $endTime } }
) {
aggregate {
count
sum {
amount
}
}
}
}
Hi @Akshat_Kaushik Thanks for reaching out! You should be able to use moment().format(), a library that comes with Retool by default, to manipulate the date to the proper format