Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 Buy | 3000 | 2000 | 1000 |
Apple | 2300 | 3400 | 3200 |
Walmart | 9800 | 5600 | 4300 |
Costco | 1600 | 1400 | 1900 |
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_Sale | Count |
---|---|---|
Best Buy | Phone-sales_Count | 2000 |
Apple | Phone-sales_Count | 3400 |
Walmart | Phone-sales_Count | 5600 |
Costco | Phone-sales_Count | 1400 |
If you can please give me solution for any one of the scenario that will solve the purpose. Thanks in advance.
It is not too complicated, it works on Scenario 2 with Type as additional Dimension. Thanks for your reply though!