Forum Discussion

TheShowMustGoOn's avatar
TheShowMustGoOn
Regular Visitor
2 years ago
Solved

Slicer and Visual interaction help

Hi,

 

I'd like to show product crossover as a visual, let's say a funnel, which will show me the product with the highest crossover with the one I've selected at the top, down to the lowest at the bottom. I'm having trouble using slicers to get the funnel to show this correctly.

 

Example data - first 2 columns are an example of the data I'm providing, others show table form of how to present it (product crossover % is how the funnel should show).

I'm looking at the product APPLES and seeing what other products, the customers who purchased apples also purchased.  All of them purchased Oranges, 50% of them purchased bananas, 25% of them purchased pears and plums.

Customer IDProduct  CUSTOMER DISTINCT COUNTPRODUCT CROSSOVER
AAPPLES APPLES4100%
BAPPLES ORANGES4100%
CAPPLES BANANAS250%
DAPPLES PEARS125%
ABANANAS PLUMS125%
BBANANAS    
CPEARS    
DPLUMS    
AORANGES    
BORANGES    
CORANGES    
DORANGES    

 

I want to filter the visual by the customers who purchased product name APPLES. But still show all the other products.

 

- When I have a funnel visual with product name (category) and distinct customer ID count (values) it shows number of customers per product for my whole database as expected

No slicer filter selected

- When I add in a slicer for product name, the funnel only shows the customer count for that one product

 

 

- I added in another slicer for customer ID and have all selected, with a card to show customer count, this changes as I select product.

- I have edited interactions so the product name slicer does not filter the funnel visual, but the customer ID slicer does - in theory I hoped this would mean the funnel would only show products for the customer ID's in the second slicer. It doesn't, it remains as the whole database.

 

- If I use the customer ID slicer to multiple select customers, it does what I want it to do. But I want to do that by product not by customer ID.

 

 

I need the product slicer to power the customer slicer, which then powers the visual... but still shows non-filtered products?

 

Any ideas?

Thanks!

  • lbendlin's avatar
    lbendlin
    2 years ago

    Invest in a data model. Won't work with a single table.

4 Replies

  •  Does your data model look like this?

     

    Your sample data and your expected outcome don't seem to match. Please provide sample data that fully covers your issue.
    Please show the expected outcome based on the sample data you provided.

     

  • Hello,

    Customers and products are in the same table in my example, 2 columns. So no relationships etc. 

    Thanks!

    • lbendlin's avatar
      lbendlin
      Super User

      Invest in a data model. Won't work with a single table.

  • Thank you. I'm learning as I go along so I appreciate your help. This now works as I wanted it to.