Practically:
- Use your FILTER_COUNTS_RAW or equivalent sheet
- Group data by Region + Industry
- Select the top 5 industries based on frequency/count per region
- Display them (e.g., bar chart per region or grouped bar chart)
Create a chart that includes both raw numbers AND normalized values (percentages) per region.
Practically:
- Use total results per region (from your base search)
- Calculate: percentage = (count / total results per region)
- Show either:
- a chart with percentages, or
- a combined chart (counts + percentages)
Leave a Reply
You must be logged in to post a comment.