Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Item Mix Visualization

so i have 4 columns of binary data    i want to be able to filter through the combinations of the 4 how can i do that? ie if i have product 1 and product 2 vs having all 4 products?   when i t...
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi Anonymous

 

Any chance you can post a small example set of data?  That might make it easier to understand what you are after. :)

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

     

    1 meaning they have that item and 0 meaning the dont

    i want to be able to see the different combinations of items customers buy and how it affects my total revenue 

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      9 years ago

      Hi Anonymous

       

      So for the above example, what is your ideal result?  Can you also mock that up in Excel?

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        9 years ago

        and are those rows individual transactions or purchases over time?