Line chart with dates

[#1]

I have a file with three fields: date, request received, request answered for a month with random dates.

For example:

Date                Request received Request answered

01/01/2014     125                              57

01/05/2014     154                              48

01/06/2014     187                              25

01/21/2014      124                             47

01/28/2014      165                             52

In the line chart i am using Date as dimension and looking at the data it is for the month of Jan. I want to display the line chart for all dates in Jan (31 days), from 1st of Jan to 31st of Jan.

Missing dates like 01/02/2014, 01/03/2014, 01/04/2014 upto 01/31/2014 i want to consider request received and request answered as 0.

I have created master calendar but that will not pick complete dates in Jan

Can someone help me what expression i have to write in dimension.

[its_anandrjs]

Try with the properties in the line chart and select Date dimension and then un-check the option Suppress When Value Null  option but check if you are using Date field with Master calendar created.

[#3]

Suppress When value Null will help only when you have dates in dimensions and with a value of null or 0. In this case as I mentioned above we do not have all dates in jan in the file.

Something we have to do in dimension expression to pick-up all dates for the month (Jan) irrespective of where there is a record in the file then as you said we can uncheck the option Suppress When value Null

[maxgro]

see attachment for an example

[#5]

This example will not work as i have to create for all months.

I have created master calendar which displays all days of each month.

But the twist is, as soon as you select a product Date dimension will pick only the dates that are available in file.

For example

Product A:

Date                Request received Request answered

01/01/2014     125                              57

01/05/2014     154                              48

01/06/2014     187                              25

01/21/2014      124                             47

01/28/2014      165                             52

Date dimension will pick only above mentioned dates for Product A

Product B:

Date                Request received Request answered

01/01/2014     199                             57

01/02/2014     135                              48

01/03/2014     165                              25

01/20/2014      174                             47

01/30/2014      185                             52

[Anonymous]

Hi

This might help you.

[#7]

This example will not work as i have to create for all months.

I have created master calendar which displays all days of each month.

But the twist is, as soon as you select a product Date dimension will pick only the dates that are available in file.

For example

Product A:

Date                Request received Request answered

01/01/2014     125                              57

01/05/2014     154                              48

01/06/2014     187                              25

01/21/2014      124                             47

01/28/2014      165                             52

Date dimension will pick only above mentioned dates for Product A

Product B:

Date                Request received Request answered

01/01/2014     199                             57

01/02/2014     135                              48

01/03/2014     165                              25

01/20/2014      174                             47

01/30/2014      185                             52