Parameter & Custom Calculated field Linking

Question & Answer
, , ,
1

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 Organization field , lets name the parameter organization.

Requirement :
I want to create a calculated field say Customzone based on this organization parameter, such that when User selects Organization = A in the parameter, then the Customzone field should be populated with the corresponding string value i.e. North in this case.

How can I achieve this in QS using calculated fields?

2

Welcome to the QuickSight 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 details: Optimize queries using dataset parameters in Amazon QuickSight)

3

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.

4

In the calculated field definition, you can define it like this below:

image
image1907×332 13.4 KB

let me know if when a user select the parameter as A, Customzone will show North.

5

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

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

7

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