Hi All, My dataset has 2 fields Organization and Zone. Zone is unique to an Organization i.e. an organization cannot have 2 zones. Organization Zone A North A North A North B South B South B South C East C East C East I have a single select parameter which takes values …

In the calculated field definition, you can define it like this below: [image] let me know if when a user select the parameter as A, Customzone will show North.

Welcome to the Quick Sight Community and thank you for asking your question here. In the calculated field definition, you can refer to the zone field in the dataset since you have 1-1 mapping between Organization and Zone. You may also want to look into dataset parameter. Here is an article with the…

Hi Xing, Dataset parameter won’t work for me, I don’t aim to filter the entire dataset, and I want this computation entirely at analysis level.

I want all rows in the customzone field to be populated as ‘North’ in this case This won’t work

Hi All, Would appreciate help with the above problem if anyone has encountered such a use case before.

Parameter & Custom Calculated field Linking

Q&A

Xing February 6, 2024, 3:43pm 6

If the above solution does not work for you, we can help you further after you replicate your use case and issue with a simple dashboard and non sensitive data at our Arena: QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community

Topic		Replies	Views
Parameter Values linked to Calculated Field Q&A filters , parameters , quick-sight , calculations , Business-Intelligence-Engineer	2	189	March 15, 2024
Values into Parameter Q&A feature-request , quick-sight , Business-Intelligence-Engineer	5	1415	March 14, 2024
Passing value from calculated field to a parameter Q&A filters , parameters , quick-sight	4	4877	June 13, 2024
Parameter for Calculated field Q&A analysis , parameters , quick-sight , Business-Intelligence-Engineer	4	590	November 28, 2023
Using parameters in calculated fields Q&A admin , quick-sight	7	193	July 16, 2024

Parameter & Custom Calculated field Linking

Related topics