3 Replies Latest reply: Mar 2, 2012 3:15 AM by Dan-Ketil Jakobsen RSS

    Period chart, calendar

    Dan-Ketil Jakobsen

      Hi

       

      I want to create a periode selection that shows year, month, week and then date and days.

       

      Something like the picture below.

       

       

      montue
      wedthufrisatsun
      1234567
      891011121314
      15161718192021

       

      My problem is that I cant figure out how to do that.

      And yes I have tried the calendar object, but that one is just ugly. I do not like it, and it does not give me the dayname.

      Also I want to create this in a container and I want to use it with both the date and dayofyear.

       

       

      Any one know how to solve this?

       

      Dan

        • Period chart, calendar
          Dan-Ketil Jakobsen

          You can disregard this. I found a way to solve it.

           

          Dan

            • Period chart, calendar
              Håkan Fast

              How did you solve it?

               

              Im looking to do somthing like that, but I would also display a calculated sales number on each date i the calender.

                • Period chart, calendar
                  Dan-Ketil Jakobsen

                  Hi

                   

                  Actually all I did was that I created a pivot chart with two dimensions and one expression.

                  The two dimensions I use is week and dayname.

                  Expression is weekdate. =WeekDate

                   

                  Week(ActualStartTime) as Week,

                  Day(ActualStartTime) as WeekDate,

                  WeekDay(ActualStartTime) as DayName

                   

                   

                  Then I left click the DayName and drag it to the top of the chart.(Not sure what that is called)

                   

                  One problem with this method is that if you do not have any sales on a given day, that day will not appear in the chart.

                  I assume I could correct this by adding an inline fucntion where I just create a set from 1 to 31 and called that weekdate

                   

                  In your case I guess you would need the expression =sum(sales)

                   

                   

                  BR

                  Dan