How to get sum (sales) till last week?
I have one scenario, where I have to calculate sum(sale) start to till date---which I am able to get. but I also want sum(sales) from start to last week (Means start to today -7 days), That I am un...
Forum Discussion
Hi BharatKankate ,
Try the below approach:
Add a widget filter to the date field. In the filter popup, set 'Day' as level and add the below custom jaql (assuming the start date is within the last 99999999 days)
{
"last": {
"count": 99999999,
"offset": 7
}
}
-Hari
