Filter relevant values based on a calculated field

Biswajit_1993 · April 17, 2023, 8:45pm

Thanks for posting your query in the QuickSight community platform.
Coming to your problem I am facing the same issues when I am trying to use the calculated field as filter and use as relevant value but it has no options for the cascading filter.

**So for that you need to create any calculated field on the Dataset page area and use that field as filter in the analysis area. The you can show the show relevant options available for the filter.

Please find below the two picture where you can see the Calculated Field created in the Dataset area and Calculated Field created in the Analysis area.

So here if I want to add Show Relevant value on the basics of Test Data - Analysis Level Calculated Field or Employee Name it is not possible if you created the calculated field on the analysis area.

You can clearly see the Show relevant vale option is not available for the Test Data - Analysis Level Calculated Field. Only this option is available for the dimension filter.

So I created the same calculation on the Dataset level and its working fine.

If you see the Show Relevant option is not available previously on the analysis level calculated field but in the data set level calculated field the options is available.

So this is the way to add the filter relevant values based on a calculated field.

Thanks & Regards
Biswajit Dash