Hi there! I have a series of content data (blog posts, social media posts, etc) that has been tagged according to content. For instance, for each blog post, it is categorized as one or more of the following:
Wineries
Educational/Info
tips
Recipes
Crafts
Events
Seasonal
Each post can have up to three categories.
A small screenshot of of how the data is structured is here: https://imgur.com/a/yAIJ1
(I tried Forum Tools, but it's not working in Mac 2016)
---
My issue is that I'm trying to summarize the data by category for a single metric. For instance, what's the average Engagement Rate for each of the above categories? When I try to build in a pivot table, it begins to get nested and all crazy.
Any advice on how to better structure the data or build the pivot table / analysis?
Thank you!
Wineries
Educational/Info
tips
Recipes
Crafts
Events
Seasonal
Each post can have up to three categories.
A small screenshot of of how the data is structured is here: https://imgur.com/a/yAIJ1
(I tried Forum Tools, but it's not working in Mac 2016)
---
My issue is that I'm trying to summarize the data by category for a single metric. For instance, what's the average Engagement Rate for each of the above categories? When I try to build in a pivot table, it begins to get nested and all crazy.
Any advice on how to better structure the data or build the pivot table / analysis?
Thank you!
