I would like to get True and False as mentioned below output rather than getting 1 and 0. Please help me to get this output. Id Amount Date Amount_in_2020 1 10 2019-01-15 True 2 0 2020-01-16 False 3 100 2019-12-21 False 4 34 2020-01-15 …

@raju123 Could you elaborate your question. What I understand that you want True and False instead 1 and 0 as output. You can try creating a calculated field and use ifelse(condition, TRUE, FALSE). If you want True and False output as a string put quotes around it - ifelse(1>0, “True”, “False”)

How to create Boolean calculated field

Q&A

Sanjeeb2022 March 18, 2023, 10:34am 4

@raju123 - Can you please provide your expected output…

Regards - San

1 Like

Boolean for Aurora PostgreSQL Data

Topic		Replies	Views
Calculated field - changing type Q&A calculations , Business-Intelligence-Engineer	8	282	December 14, 2023
I need help with a calculated field Q&A quicksight , dashboard , calculations , Business-Intelligence-Engineer	1	182	October 5, 2023
Replace boolean 1 and 0 values with user-friendly strings Q&A formatting , feature-request	1	2670	September 8, 2022
Unable to present calculated field Q&A quicksight , Business-Intelligence-Engineer	4	100	April 9, 2024
Help building a calculated field Q&A quicksight , calculations , Business-Intelligence-Engineer	1	16	March 21, 2025

How to create Boolean calculated field

Related topics