Compare Daily sales with Sales 28-days before on bar chart

[ambasadorknz]

Hi,

I have to compare daily sales with sales 28-days before. 

I can do that when i select one Day:

sum({1<fl_run={1},run_year={"$(=text(year(run_year-28)))"},run_month={"$(=text(num(Month(run_month-28))))"},run_day={"$(=text(Day(run_day-28)))"}
>}sales)

but it not working for more then 1 day

Yes, I know ... i have to convert data:)

Any suggestions? Please?

Example:

Day	Sales	sales -28d
2020-01-01	1164052	989444
2020-01-02	15026568	12772582
2020-01-03	17073342	14512341
2020-01-04	6342360	5391006
2020-01-05	2389451	2031033
2020-01-06	3150754	2678141
2020-01-07	15919457	13531539
2020-01-08	18541307	15760111
2020-01-09	18304504	15558828
2020-01-10	18337210	15586628
2020-01-11	6142253	5220915
2020-01-12	3562535	3028155
2020-01-13	19063465	16203945
2020-01-14	20008688	17007385
2020-01-15	17830123	15155605
2020-01-16	17406119	14795201
2020-01-17	1815579	1543242

[Kashyap_R]

Hi

If your date is not skipping then you can use this for before - 28 days

Alt(Above(Sum(Value),28),0)

Hope this helps 

thanks