Display curve with condition

[#1]

Hello,

I have a table like this one

Ref	Work Order	Work Center	Date	Total Time	Variation
A	1	WO1	2015/45	10	25
B	2	WO1	2015/45	5	14
A	3	WO2	2015/46	15	5
D	4	WO3	2015/47	2	-4
C	5	WO1	2015/45	4	5
B	6	WO2	2015/49	5	-15
A	7	WO1	2015/45	10	25

This table gives for each Work Center for each date the total time produced on this work center and the variation compared to the last 4 weeks.

I would like to display on a graph only the evolution of the production time of the work center where variation is >10 (if we are 2015/46, i want to see the evolution during the year of production of the work center where variation is >10).

How should i perform this?

[#2]

Seems to work, thx, but was is the role of DateNum? It doesn't seem to count weeks in chronological order

[swuehl]

Ok, then you need to fix this, as I mentioned above, create a sequential DateNum in chronological order, just to make the previous week calculation much more easy.

You can also work upon a date field that shows am underlyin numeric representation, but then formatting issues need to be considered:

Dates in Set Analysis