I want to create the graph below from a dataset.(*The yellow shaded columns in the dataset are columns created for aggregation purposes and do not exist in the actual input.)
↓dataset
↓graph (x-axis: #Classification, y-axis: number of companies, color: PercentageOfWomen)
However, the calculated field I created cannot be set on the X-axis because of the error “Custom aggregated fields cannot be used as dimensions.”
Is there a good solution?
The details of what was carried out are shown below.
(1) I created a calculated field to calculate sales per person. #SalesPerPerson
{Sales}/{NumberOfEmployees}
(2) I calculated percentile rank from sales per person. #PercentileRank
(4) When I try to set the last created category field to the X axis of a stacked 100% bar chart, I get an error saying “Custom aggregate fields cannot be used as dimensions.”
If i use you data and the calculated fields i’m getting the same error. But i’m also not able to show your table as a QS table visual. Do you get the same error?
Please note that QuickSight does not support the use of calculated fields with aggregation as a dimension group.
Instead, you must utilize the LAC-W (Level Aware Calculation) with PRE_AGG or PRE_FILTER to achieve row-level aggregation.