Forum Discussion

jeffr's avatar
jeffr
New Member
8 years ago

chart with start and end date

I would like to create a line chart based on data that only has a start and end date.

 

Here is a sample of the data

 

Type Start Date End Date

IW12/01/201712/31/2017
IW12/01/201712/31/2017
JL12/01/201712/31/2017
JL12/01/201712/14/2017
EC12/15/201712/31/2017
IW12/01/201712/24/2017

 

Ideally it would group based on Type and then create a line chart with the Y Axis as Type and the X-Axis would be the Start Date to the End Date range.  Then for each day in between start and end it would have the Count of Type.

3 Replies