Calculated field with partition field not available if partition is not added to the pivot table visual

Question & Answer
, ,
1

I have a dataset with column like Country, City, StudentName, StudentScore and ScaledStudentScore(calculated)

I am able to create calculated fields to calculate the Mean using Avg, Standard Deviation using stdevpOver(StudentScore,[Country, City]) and Z-Score in a pivot table with rows [Country, City, StudentName] and values [Mean, StandardDeviatuon, Z-score]

My ultimate goal , is to sort by the Z-score ( generated to the partition level of [Country,City] ) only by [Country and StudentName]

I tried using “Pre_filter” in the Standard Deviation calculated fields but it won’t allow me due to the Operand ( ScaledStudentScore is aggregated )

And if don’t have City in the pivot table rows then the table is not visible due to the missing details where City is part of the calculated field.

Can this be achieved within Quicksight Analysis without modifying the dataset ? Thanks

2

Hi @W_H ,

Welcome to the QS Community!

For your use case, you can hide the partition field after adding it to the pivot table.

Thanks,
Prantika

3

We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.” (click the check box under the reply)