How to get sum (sales) till last week?

Help and How-To

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 unable to get.

Highly appreciate response on this.

BharatKankate

Posted 1 year ago·Last reply 1 year ago

4 comments

BharatKankate

OP1 year ago

Thanks that works

harikm007

·1 year ago

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

DRay

·1 year ago

Hi BharatKankate,

Thank you for reaching out. I want to make sure I understand the ask here. Are you wanted a total, but exclude the previous 7 days of data, or do you want the total as of the end of the previous week?

BharatKankate

OP1 year ago

I wanted a total, but exclude the previous 7 days of data.