Hi all,
I have created a dashboard that visualizes a specific brand's reviews by their rating and theme of review.
I used a matrix that visualizes how many reviews are related to a specific theme, subctegories within the themes, and products. I then use columns to break it down further by showing the same data for each individual star rating.
What I am now trying to accomplish is to allow the viewer to use a filter or slicer element to choose a specific industry and see the data for the desired industry. For example, selecting "automotive" and only showing data for reviews related to a product that is classifed as an automotive industry product.
The data is set up with each row being an individual review. The following columns include data such as the star rating, product id, theme, subcategorized themes, and finally Industry.
Where I am having trouble is with the fact that many of our products have multiple industries associated with them. For example one of our products may have all of the following industries: automotive, manufacturing, transportation, and maintanance.
I can attach the data as a delimeter separated list in one column or have them split into different columns.
However, I have issues with both options.
Using a delimeter seperated list - I do not know how to then be able to use that column to use a filter or a slicer filter. I don't have any knowledge if it is possible to use the data in that form.
Using seperate columns (6 columns as the products with the most industries has 6 industries) - I do not know how to combine data values (industries, For example manufacturing) if they are in different columns. For example if a product only has 1 industry, manufacturing will be in column: industry.1, but if the product has 3 industries manufacturing may be in column industry.3. Therefore I wouldn't be able to use any of the columns to include all reviews with a manufacturing related product.
I'm not sure if this will make any sense to anyone. However, I figured I'd give it a shot. Any ideas, knowledge, or questions are welcome.
Thanks!
