2 Replies Latest reply: Jul 25, 2016 11:46 AM by Carlos Daniel RSS

    Building a comparison page

    Carlos Daniel

      Hi there,

       

       

      I'm trying to build a page that has two similar charts, and two sets of identical filter panes. How can i set this up, if i want a a filter pane to only influence one the charts?

       

       

      Thanks.

        • Re: Building a comparison page
          Chandrasheker Gompa

          Hi,

           

          I have a KPI chart and 4 filters and I have written an expression like below:

           

          The KPI doesn't change even when I select the filters

           

          Sum({<[Reporting Area] ={*},

          [Reporting Group 3] = {*},

          //[Reporting Group 2] = {*},

          [Reporting Group 1] = {*},

          [Reporting Group] = {*},

          File_Type = {"Actual 2016"}>}Value)/1000000

           

          So in one of the sheet where you don't want the metrics to change based upon the filter you filter name and * like above... Hope this helps.

          Thanks

            • Re: Building a comparison page
              Carlos Daniel

              Hi,

               

              I'm not sure that helps. What i'm trying to achieve is to have a filter only change one of the charts so that i can compare sets of values, something along these lines:

               

              V1zAXXo.png

               

              In this example i'm using the calculation condition, but if both conditions are met then both charts are affected by the selections above.