Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data Analysis - Trend Analysis, Conditional formatting, Matrix/Table Chart counts.

I have a dataset of Products that are listed in various websites(Own Website, Amazon and Others) and is marked as present with '1'.
1. I want to analyse this data to check the number of unique products present in these website(basically the count of products in each of these sites and the combinations too).

a. Own Website(not necessarily all products to be listed in own website).
b. Amazon.
c. Other websites


2. Visually represent the products/count of products which are present in combination of these webistes(for ex: Own Website+Amazon,Own Website+Others,Others+Amazon etc.,)


3.Count of Unique Products listed in all the 3 categories of websites.

 

Can someone please help with this, also please let me know if additional info is required.

 

Thanks in advance!

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    The results are as follows.

    You can download my attachment for more details.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    The results are as follows.

    You can download my attachment for more details.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion

    Simple enough, unpivot Amazon, own site, other sites columns to slice and dice the dataset.