1 Reply Latest reply: Sep 28, 2017 4:30 AM by Pratyush Shastri RSS

    Filter Legends help

    Amit Saini

      Hi Folks,

       

      I'm having below Line chart , what I'm looking for is any easy way of doing filtering on Legends:

       

       

      Suppose I just want to filter for Legends : SP_Time_PinchLine_L_1_Max and SP_Time_PinchLine_L_1_MIN , just to compare these two.

       

      Any suggestions how this can be possible!

       

      I tried just selecting my mouse these 2 , but it's not working.

       

      I'm thinking of creating list box with these legends on right side of above chart, so that users can select anyone to compare, but no sure if this is possible as all these are $Field.

       

      Here my Dim = Date

       

      Expressions are :

      Exp1 :AV_Tmp_PinchLine_L_1

      Exp2 :SP_Tmp_PinchLine_L_1_MAX

      Exp3 :SP_Tmp_PinchLine_L_1_MIN

      Exp4 :AV_Tmp_PinchLine_L_2

      ...

      ..

       

      and so on

       

      Thanks,

      AS

        • Re: Filter Legends help
          Pratyush Shastri

          Hi AS

           

          Create an inline where you have something like this

          Tab;

          Load * Inline [

          Dim

          AV_Tmp_PinchLine_L_1

          SP_Tmp_PinchLine_L_1_MAX

          SP_Tmp_PinchLine_L_1_MIN

          AV_Tmp_PinchLine_L_2

          ];

           

          so you can have a listbox where you can choose which line charts to show up.

           

           

          Now create a listbox with Dim as your field

           

          and then go into your line chart, where you'll have Conditional option for each expression

          Type this for your first expression:

          GetSelectedCount(Dim)=0 or substringcount(GetFieldSelections(Dim),'AV_Tmp_PinchLine_L_1')>0


          and so on for all the expressions and you're good to play with the chart.


          Regards
          Pratyush