Line Char Help with Start and End Date

[amit_saini]

Hi Folks,

I'm having below set of data:

Main_Order	Start	End	Cost
71501	2015-02-11	2017-12-15	8809.81
71502	2015-02-26	2017-12-01	16304.07
71503	2017-12-04	2017-12-04	20167.84
71601	2016-02-10	2017-12-01	9147.59
71603	2016-11-18	2018-05-14	16178.57

My requirement is to create chart like below from this data:

Logic : What ever is start Date like "2015-02-11" , "2015-02-26" , we need to consider this as Month number 1 and based on corresponding End Date - Month number ,need to show line trend .

So in first case for 71501 ,between 2015-02-26 and  2017-12-15 = We need to create line trend from Month 1 (Feb 2015) upto Month 35 (Dec 2017).

Like wise trend for all Main orders.

Please help , no idea how to do this.

Thanks in advance!

Regards,

AS

[amit_saini]

One Min Sir

[amit_saini]

PFA

[amit_saini]

This one too.

[sunny_talwar]

This table that you are adding the AutoNumber to, doesn't have any Month_Year information....Do you have a table where you have Plant and MonthYear in a single table?

[amit_saini]

Sorry , no.

Month , Year and Cost is coming from my fact table. For cost analysis via Plants , I have used another table carrying Plant info . I'm doing Left Join by Key called Main_Orders on Fact table/

Regards,

As

[sunny_talwar]

May be take a resident load of the Fact Table and create the MonthNum field in the resident load like this

AutoNumber(Year_Month, Plant)

I have made the updates in the attached qvw file for you to check and run the updates

[amit_saini]

Thank u so much