1. Window_avg should be -2 to 0, not 3 to 0
2. create calculated field of "index"
3. Change [index] to discrete and put in Filter shelf
4. Filter index only choosing "0".
test2_SM_9.2.twbx 5.9 KB
Sorry what if my data had 3 more rows of zeros that i want to omit and only start from the last 3 where data is greater than 0.01?
date value 1/1/16 10 2/1/16 20 3/1/16 30 4/1/16 40 5/1/16 50 6/1/16 0.0 7/1/16 0.0 8/1/16 0.0
So like before, the avg of 'last' 3 will be (50+40+30)/3=40
I want to omit values where value<0.01.
i put value in the filters where value >0.01 but i think the average i want is still wrong.
Try putting below field in the filter section and seelect true.
I tried it on my data set where values are in decimals and i have 2 more columns that i filter on. the window_average did not work. it ended up just filtering to index=0 which is the last item but not doing any average.
Any idea why my other filters are affecting it?
please see test3.twbx attached.
Thanks, this help me to get the avg. 3 latest month sales. But now I'm having a new challenge.
I want to get my level inventory using total inventory / avg. last 3 month sale. Is that posible?.. For example I have 100 units inventory and my average sales are 50, so I have 2 months of inventory.
Sorry I'm new with this.
Shin, thank you very much. It worked.. I was doing it without the SUM formula.
1 of 1 people found this helpful
You are very welcome.
Could you mark my answer as correct?