Hello Quick Sight Community, I’m currently working on a dashboard where I need to analyse data by shop_id. The shop_id column in my dataset is of string datatype, which is necessary for enforcing Row-Level Security (RLS). To perform analysis on shop_id, I’ve created a calculated field using parseI…

Hi @esther_a I am not sure why you ended up creating the shop_id_int calculated field. You could simply create a Parameter based on the original shop_id column and then filter the visuals on shop_id column linked to your parameter. It should just work; unless there is some nuance in your case that…

Hi @Giridhar.Prabhu I did this initially but whenever I clicked a Shop ID from the drop down list I received an unhelpful filter error for the visuals with calculated fields that the Shop ID filter was applied to, it doesn’t work, which is why I am here asking why. The visuals returning the error a…

Hi @esther_a The formula still does not seem like should cause a problem. Can you share the error message that you get? Regards, Giri

Hi @Giridhar.Prabhu , here it is [Screenshot 2024-08-29 100602]

Hi @esther_a I tried to simulate the issue by creating a sample dataset as follows [image] I created a parameter on Shop Id (String column); Create the measure as follows [image] I added this measure to a visualization and applied the filter on shop id [image] When I filter the visualization…

You can refer to this post on how to create your case Arena [image] NEW - QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community Blog [FeatureTile] QuickSight Arena provides you with an embedded instance of QuickSight right within the Quic…

Ah, so the calculated field in your simulation includes the field that it’s being filtered by, in my analysis the ‘id’ ← in the formula ‘sum(hours)/distinct_count(id)’, refers to another column that isn’t ‘shop_id’ and is of an integer data type

Were you able to upload your case to Arena? If you have I can take a look at the issue.

Hi @esther_a , It’s been awhile since we last heard from you; did you have any additional questions regarding your topic or were you able to find a work around? If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic. Thank you!

Hi @esther_a , Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for any relevant information that may be needed. Thank you!

How to Filter Calculated Field Visuals Using Parameters Linked to a String Column?

Q&A

Giridhar.Prabhu August 29, 2024, 11:02am 8

You can refer to this post on how to create your case Arena

Topic		Replies	Views
Getting parameters to properly filter based on filter instead of "ALL" Q&A filters , parameters , quick-sight	7	3441	April 21, 2023
Limitation of calculated field Q&A developer , quick-sight , qls-community	4	60	February 14, 2025
Connecting filter to calculated field Q&A filters , quick-sight , calculations , Business-Intelligence-Engineer	3	55	May 28, 2025
Issue adding a calculated field as a filter Q&A analysis , quick-sight , Business-Intelligence-Engineer	5	604	November 29, 2023
Visual filter using calculated field Q&A filters , quick-sight , calculations	12	3954	October 6, 2022

How to Filter Calculated Field Visuals Using Parameters Linked to a String Column?

Related topics