Area chart with 2 dimensions

[linoyel]

Hi, I need to create an area chart with 2 dimensions as shown in the WantedResult picture attached.

My problem is that at the end of each sprint the line is not vertical, as well as at the beginning of each sprint the area starts from the day before actual sprint start date.

If the last sprint date was 28.03 and there were 16 issues on this day, I need the area to go down vertically and not to go to the next date - 29.03 - please see ActualResult picture atached.

Is it possible to control this in QV?

Thank you.

[kaushiknsolanki]

Hi Linoy,

The Actual Result JPG is not opening, can you upload it again.

Regards,

Kaushik Solanki

[linoyel]

Uploaded it again in a smaller size

[kaushiknsolanki]

HI,

Can you upload a sample data set.

Regards,

Kaushik Solanki

[#5]

Hi,

This is the best i could do:

I have taken the sample data as following:

Date_1	Value
1/1/2017	99
2/1/2017	100
3/1/2017	109
4/1/2017	111
5/1/2017	222
6/1/2017	333
7/1/2017	345
8/1/2017	234
9/1/2017	235
10/1/2017	236
11/1/2017	237
12/1/2017	238

Try this expression :

if((sum(Value)-Above(sum(Value)))<0,0,Value)

Regards,

Sanya Chauhan