5 Replies Latest reply: Jul 14, 2016 10:52 AM by Brian Copple RSS

    Month to Week drill down in a bar chart

    Ga Baga

      Hello,

       

      Is there a way to achieve Month to Week drill down in a Bar chart?

      The attached image shows the Sales by Month Year and i am looking to drill down to the weeks when the lines are selected. Each line represents a country.

      Dimension 1: Month Year

      Dimension 2: Country

       

      Expression: Sum(Sales)

       

      Thanks.

        • Re: Month to Week drill down in a bar chart
          Marcello Giacomel

          Hi!

           

          If you already have the Week field in your QVW, you just need to create a cyclic group with Month first and than Week. And then delete the Month dimension of the chart and after add the cyclic group as dimension.

           

          If you don't have the field Week or if isn't this the problem, please attach an example application (QVW).

           

          Best regards,

           

          Marcello

            • Re: Month to Week drill down in a bar chart
              Ga Baga

              Thanks for the reply Marcello.

              For your solution to work,the user has to click on the cyclic icon to switch between the months and weeks. is there a way to automatically change the axis values from months to weeks based on the selections? Assume that the user select a month or two, then the chart axis value should switch to weeks instead of months. is it possible?

                • Re: Month to Week drill down in a bar chart
                  Krishnaraj M A

                  Hi,

                   

                  Try to use the drill down group

                   

                  hope this is helpful.

                  • Re: Month to Week drill down in a bar chart
                    Marcello Giacomel

                    Hi Gamavi

                     

                    Solution 1:

                    The Drill-down Group is the way to automatically change the axis values from months to weeks based on the selections, but to perform the drill-down you have to select just one month. The group icon (button) shold be used to drill-up.

                     

                    Solution 2:

                    If you don't want to use groups, you can try to create 2 charts over positioned: one with month as dimension and other with week as dimension. Then use the Conditional Show property (in Layout tab) to show the Week chart only when there is at least one month selected (for this, use GetSelectedCount () function). If you clear the selection, the Month chart will be automaticaly showed.

                     

                    Hope it helps!

                     

                    Marcello

                • Re: Month to Week drill down in a bar chart
                  Brian Copple

                  Drill down group will be the best option for you. Just create a new group on the dimensions tab and choose the radio button for drill down and add in both your month followed by week fields. Then use this group as your chart dimension.