6 Replies Latest reply: Oct 16, 2014 6:50 AM by Vamshi Mekala RSS

    Line chart with dates

      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.

        • Re: Line chart with dates
          Anand Chouhan

          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.

            • Re: Line chart with dates

              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

            • Re: Line chart with dates
              Massimo Grossi

              see attachment for an example

                • Re: Line chart with dates

                  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

                    • Re: Re: Line chart with dates
                      Nils Morris

                      Hi

                      This might help you.

                        • Re: Line chart with dates

                          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