10 Replies Latest reply: Feb 16, 2017 2:29 PM by Chaitanya Mopathi RSS

    Table Columns in Filters - Stacked Bar Chart, It is Interesting but challenging

    Chaitanya Mopathi

      Hi,

       

      This is probably a brain teaser and Please help me with simple logic.


      I have 2 scenarios so that, if you can suggest me solution for any one of the scenario my problem will be solved. The help is appreciated.


      Scenario 1:


      Here is the table.

       

      Merchant    Phone-sales_Count Store-sales_Count Online-sales_Count
      Best Buy300020001000
      Apple230034003200
      Walmart980056004300
      Costco160014001900

       

      Now I am plotted a Stacked Bar Chart with below parameters:

      Dimension:        Merchant_Name

      Measures:          Phone-sales_Count, Store-sales_Count, Online-sales_Count

       

      Now I want to have a Filters which actually filters between the measures ( Phone-sales_Count, Store-sales_Count, Online-sales_Count), so that the stacked chart will show the selected measure data only.


      Filter_Sales
      Phone-sales_Count
      Store-sales_Count
      Online-sales_Count

       

      Please help me How can I do that.


      Scenario 2:


      I changed the table and data format to below as the filter does not work for me.

      But this time, the filter worked but the stacked chart is not working because I can select only count.

       

       

      Merchant  Type_of_SaleCount
      Best BuyPhone-sales_Count2000
      ApplePhone-sales_Count3400
      WalmartPhone-sales_Count5600
      CostcoPhone-sales_Count1400

       

      If you can please give me solution for any one of the scenario that will solve the purpose. Thanks in advance.