4 Replies Latest reply: Aug 18, 2011 5:28 AM by Razor Ramon RSS

    Compare Charts Using a Slider

      Hi,

       

      I have a requirement to create a page that contains two charts and give users the ability to use one or more sliders to select months and compare them against each other.

       

      For example, I will like to show in one chart selections for Jun-11 and in the second chart selections for Jan-11 by adjusting the sliders only, so that people can look at both charts at the same time and make a quick comparison between months on the fly. I tried doing something with a slider, but each time I adjusted the slider it affected both charts and not just one chart.

       

      Is there a way to do something clever with say two sliders to get this to work?

       

       

       

      Thanks

        • Re: Compare Charts Using a Slider
          Steve Baldwin

          Hi there are a couple of ways you can do this, the first is using 2 variables using an input box to set the variables, then have an expression in each chart that looks like this

           

          sum({<Period = {$(v_month2)}>} Sales)

           

          or you could have 2 data islands you could then use a slider to select from each and have expressions in your charts that look like this

           

          :sum({<Period = {$(=only(Period2))}>} Sales)

           

          I have attached an example that uses these tweo methods, hope this helps

           

           

          Thanks

          Steve

            • Compare Charts Using a Slider

              Thanks a lot Baldwin.

               

              Both solutions do the trick.

               

              Just out of curiousity, is there a way I can do the slider bit without creating the date island?

               

               

              Thanks for your help once again

                • Re: Compare Charts Using a Slider
                  Steve Baldwin

                  Hi, well not neatly.. however you could pick the start number as 201101 and the end number as 201112 with an increment of 1 for both sliders and attach each of the variables to the sliders. of course this doesn't work if you want to jump to the next year as as far as the slider is conserned the difference between 201112 and 101201 is 89 as the slider just views it as an interger... you could have a second slider for each of these sliders that would pick the year and the start and end values of the sliders as a function of the variables attached to the secondary variables. so if the variable was v_pickyear with a start and end of 2009 and 2010 you could set the start and end of your month selecters with the functions

                  =v_pickyear &'01'

                  =v_pickyear &'12'

                   

                  but this is getting a bit messy i would probably stick to the data islands.

                   

                  Thanks

                  Steve