Weekly trends chart

[#1]

Hello,

I have a line chart with year-week and sales_area as dimensions and net sales as expression. For net sales I have to sum 3 separate fields in the table say sale_1, sale_2 and sale_3.

So my expression is something like

AGGR((SUM(sales_1) + SUM(sales_2) + SUM(sale_3)),sales_area,year-week)

Not all sales_area may have made a sale in any particular week.

How do I get the chart for say last 4 or 5 weeks only? I tried using dimension limits for year-week (largest, smallest, first) but I am not getting correct results as sometimes the weeks are not continuous, sometimes some sales areas are not displayed etc.

thanks for helping.

Manoj

[#2]

Hi,

You could modify your chart some thing like :

if(week(today())-Week(field)>4,exp)

If possible upload sample.

Kiru

[maxgro · Accepted solution]

PFA

[#4]

Hi,

Please have a look at the attached file and hopes it help!

Kiru

[#5]

Hi Massimo,

Somehow SUM({$....} sales1 + sales2) doesn't work for me but SUM({$...} sales1) + SUM({$...} sales2) does.

I noticed the same thing in my another dataset as well.

thanks,

Manoj