8 Replies Latest reply: Jun 9, 2015 12:28 AM by Kumar Pramod RSS

    weekdays

    Kumar Pramod

      HI all,

       

      In the attached .qvf file. for the client id = 15, all the data is showing only for Monday.

       

      but the data should display on the particular day.

       

      Please help me to get the data according to the days.

       

      Thanks,

      pramod

        • Re: weekdays
          Gysbert Wassenaar

          In the attached .qvf file. for the client id = 15, all the data is showing only for Monday.

          There is only data for the Mondays in the week_Day dimension for client id 15.

           

          but the data should display on the particular day.

          I don't understand. Can you explain with an example what you mean?

            • Re: weekdays
              Kumar Pramod

              HI Gysbert Wassenaar,

               

               

              In image you can see bars are displaying only for monday.

               

                   The CTR measure is having only on monday. but other two measures (signups and completion) have data on other days(tue,wed, thu,fri,sat, sun) instead of displaying on other weekdays, those data is also dispalying on monday.

               

              Thanks,

              Pramod

                • Re: weekdays
                  Gysbert Wassenaar

                  The other measures do not have data on other days in the week_Day dimension for client id 15.

                    • Re: weekdays
                      Kumar Pramod

                      HI Gysbert Wassenaar,

                       

                      In the attached image you can see the data on other days of the week.

                       

                      I think for week_Day dimension, i have used the "date_created" field. This is not in other two tables. May be this is causing the issue.

                      Iin the weekdays.qvf attached file you can see the sheet2 where it shows the data of other two measures.

                       

                      Will you please check and help on it.

                       

                       

                      week.pngweek1.png

                       

                       

                      Thanks,

                      Pramod

                        • Re: weekdays
                          Gysbert Wassenaar

                          Let's try that again:

                           

                          The other measures do not have data on other days in the week_Day dimension for client id 15.

                           

                          The week_Day1 and week_Day2 dimensions are not the week_Day dimension. You cannot show values from three different dimensions in that one dimension you used in your chart.

                            • Re: weekdays
                              Kumar Pramod

                              sorry. you are correct.

                               

                              Week_Day don't have data for other days. but it have data for week_Day1 and week_Day2.

                               

                              I need to combine all three and need to display the data. Is this possible?

                               

                              I read that we can combine all date fields through master calendar or cannonical date. Is that possible?

                               

                              If possible please explain how to do it for our date fields?

                               

                              Thanks,

                              Pramod