Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
see attachment for an example
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
Hi
This might help you.
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