4 Replies Latest reply on Feb 13, 2019 6:25 PM by Zhouyi Zhang

    Stacked bar chart with multiple dimensions and aggregate count

    Axel Urde

      Hi,

       

      I have a dataset containing information on different products categories with certain functions. Each product has a main category (such as lighting) but can also fit into several other categories as it may have other functions (such as being being an energy meter). What I want to do is to create a bar chart for each main category then stack the sub-categories on top of the main category, and showing a total count per sub-category. So, for example if I have 100 lighting devices and 20 of those are are energy meters, and 5 are dimmers I want the bar to show: Lighting: 100, Energy meter: 20, Dimmer: 5, even though it's only 100 products, as I want to see how many products with each function is available.

       

      Thankful for help!

       

      Best