Help creating a chart!!!

[bazzaonline]

Hello,  I need to create a chart that is based on two existing dimensions but not sure how??

I have two date fields

Start Date

Finish Date

I need to create a chart that shows open jobs at the end of each month.  I guess I need to create a dimension that can count the number of open jobs at the end of the month? 

Any ideas??

Thanks Paul

[sunny_talwar]

Do you have a sample you can share with us?

[Anonymous]

Did you check this?

Recipe for a Gantt chart

[ramasaisaksoft]

Hi Paul,

My Assumptions are like below

Expression u can write below one

=if(job_type='Open',

                              aggr(sum(jobs),Month(Start Date))

you can get like this.If you are not clear send us some sample data and required output so that we will help to u

[Kushal_Chawda]

what is logic to find out the number of open jobs?

[bazzaonline]

If at the given date the start data is < the month and the finish date is > that the month. 

[bazzaonline]

All,  Below is an example of what I need to do.  So it would show at the end of Jan 2 open jobs (Jobs 2 & 3) at the end of feb 3 open (jobs 3, 5 and 6 etc)

Job Number	Start Date	Finish Date	Job Number	End Jan	End Feb	End Mar
1	01/01/2016	01/01/2016	1	0	0	0
2	01/01/2016	01/02/2016	2	1	0	0
3	01/01/2016	01/03/2016	3	1	1	0
4	01/02/2016	01/02/2016	4	0	0	0
5	01/02/2016	01/03/2016	5	0	1	0
6	01/02/2016	01/04/2016	6	0	1	1
7	01/03/2016	02/03/2016	7	0	0	0
8	01/03/2016	02/03/2016	8	0	0	0
9	01/03/2016	15/04/2016	9	0	0	1

[MayilVahanan]

Hi

PFA

Hope it helps

JobNumber	Month	Jan	Feb	Mar	Apr
1		0	0	0	0
2		1	0	0	0
3		1	1	0	0
4		0	0	0	0
5		0	1	0	0
6		0	1	1	0
7		0	0	0	0
8		0	0	0	0
9		0	0	1	0