1 Reply Latest reply: Feb 27, 2012 4:03 PM by Stefan Wühl RSS

    Select month and charts reflect the weeks

      I would like to have an option for a month and 5 charts would change to reflect the 1-5 week of that month.  The end picture is to show a month of statistics with totals per week.  How can i best accomplish this?  Should I set a bookmark for each of the charts that would be a specific week?

       

      Thanks,

      Kristy

        • Re: Select month and charts reflect the weeks
          Stefan Wühl

          Kristy,

           

          you could probably just add a week field to your dates in your table, containing the date of the weekstart of that date. Then you could limit the values in each chart with a set expression to one of the weeks in that month, like

           

          =sum({<MonthName=, WeekStart={'$(=weekstart(min(WeekStart)+7))'}>}Value)

           

          for the scond week in a month, after you selected a month in field MonthName.

           

          An open issue which weeks you want to show, since weeks don't really align with months.

           

          In my attached sample, I just show all week, that have any day of the week in the selected month.

           

          Hope this helps,

          Stefan