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”)

Hey @raju123 ! Thanks for posting your question. If you don’t hear back from one of our community members or Experts over the weekend, I will make sure one our Solution Architects replies to this on Monday. Have a great weekend!

I got the solution for this. Thank you

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

Boolean for Aurora PostgreSQL Data

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

How to create Boolean calculated field

Related topics