1 Reply Latest reply on May 18, 2018 12:54 PM by swaroop.gantela

    How to filter based on the selected value's attributes?

    Cindy Do

      I want to be able to filter based on a selected value's attributes. For simplicity I created an example data set below.

       

      I want the dashboard to have two charts:

      Chart 1: Wildcard filter to enter in desired attribute (In the example below, I would type in "Cherry")

      Chart 2: Table that filters based on what is entered in chart 1 (In the example below, Cherry and Banana would show)

       

      In the example data set below, when Cherry is selected, I want the chart to filter on products that have a similar quantity and sales value as Cherry. So, If Cherry is selected, then the chart will show Cherry and Banana (because Banana is also a fruit type and has sales close to $150).

       

      ProductTypeQuantitySales
      OrangeFruit100$100
      CherryFruit50$150
      PineappleFruit90$200
      BananaFruit50$140
      HamMeat60$90
      BaconMeat100$140
      ChickenMeat50$120
      CarrotVegetable80$70
      LettuceVegetable90$80
      SpinachVegetable20$50

       

      How can I achieve this?