Aggregate Visualizations - Pie Chart

Question

Hello everyone,

I have a dynamic pie chart that houses the following data fields:

Location

Job Position

Assume there are 3 job locations: Location A, Location B, Location C

Assume there are 5 positions: Full-Time Associate, Part-Time Associate, Cashier, Stocker, Store Manager

The slicers to filter the data are on Location and Job Position

Currently, the pie chart shows each of the 3 locations and users can select the position they want to see - this will show a slice of the selected location and how many employees it currently has for the selected position.

When selecting one position at a time, this works well.

However, I want to aggregate the positions by Location.

Assume if I want to see how many Store Managers and Cashiers there are at each location (as a single slice of the pie), how can I achieve this with the pie chart? When using the slicer and selecting Store Managers and Cashiers, the pie chart will give each position it's own slice: Location (A,B,C) - Cashier, Location (A, B, C) - Store Manager. This can quickly get overwhelmingly cluttered if selecting all positions as there would be 5 separate slices for each of the 3 locations.

I'd like to see a single slice per location, based on the positions selected - rather than separate slices for different positions. So if I selected Store Managers and Cashiers, each location slice would show the data for the selected positions - but not split the locations and positions.

The image above is the current situation. I'd like each location, regardless of the positions selected, to show as a single slice, rather than different slices. How can I go about achieving this? Thanks!

Answer 1

Hi,

I do not understand your question.  Please show some data and also the expected result.

Answer 2

Hi,

I do not understand your question.  Please show some data and also the expected result.

Essentially, how can I combine each location's slice? Notice in the image how Batavia Full-Time Store Associate and Batavia Part-Time Cashier are separate slices of the pie. They are both of the location Batavia, i'd like them to display as a single slice. The same would apply to each of the other locations.

Answer 3

Hi,

So in the Base data, create another column called region where you show Batvia and other such entries.

Answer 4

This won't work though as the slice would still be split. I have a column in the data called Location. Batavia is one of the locations. To give you an idea of how the data looks:

Column A: Division (Batavia, Center Valley, Denton)

Column B: Opportunity Title (Full-Time Store Associate, Part-Time Cashier, etc)

Column C: Total Employees

If I create another column called Region, I'll be in the same predicament - the different selected Opportunity Titles will split the Division's slice.

Answer 5

Hi Grill,

Could you please upload a sample example workbook in this OneDrive link? This will help us all to understand your requirement. Please make sure to remove any sensitive information from the workbook.

Regards,

Neha