1 Reply Latest reply: Aug 5, 2016 3:52 PM by Phaneendra Kunche RSS

    Changing Multiple Measures with a single filter pane selection

    Priyash shahane

      Hey guys,

       

      I have a dataset with PC and Mobil data.

      The structure is as follows:

       

      Site,...,...,.., PC_visits,Mobil_visits,pc_minutes,mobil_minutes

       

      I m am trying to create a sheet which has a table with columns like pc_visits,mobile_visits etc. however i want the measures to change based on the filter pane selection between PC and Mobile (as a filter pane object in the same sheet)

       

      So basically, if the option PC is selected the Table should be

       

      Site          sum(PC_visits)          sum(pc_minutes)

       

      if option mobile is selected, the table should be

       

      Site     sum(mobile_visits)          sum(Mobile_minutes)   

       

       

      The two solutions i could thing of were using If else but thats not an efficient approach when the data scales. The other option was to modify the dataset in a way such that both measures for PC and Mobile are in same column with a separate flag column separating them. However it is a pain for me to do that.

       

      Is there something i can using set analysis or something to solve this

        • Re: Changing Multiple Measures with a single filter pane selection
          Phaneendra Kunche

          I would say add a inline table and do this to get what you want.

           

          Inline:

          Load * Inline [

          Metric, MetricVisits, MetricMinutes

          PC, PC_visits,PC_Minutes

          Mobile, Mobile_visits,Mobile_Minutes

          ];

           

          Note: Bolded above needs to be exact column names that you have in your data model including capitalization.

           

          In UI create a list box. You can use attached extension which has "Always one selected' value, so that you can avoid senario where user picking both PC&Mobile.

           

          In your expressions use this.

          Sum($(=MetricVisits))

          Sum($(=MetricMinutes))