Hi everyone,
I have created a calculated field - ifelse(takeoff = TRUE, 1, 0) which is legit (the system recognizes it). but unable to present it in any kind of visual. I also tried another calculated field - (COUNT(takeoff = true) / COUNT(takeoff)) * 100, but I always get this answer…
Any ideas? the system pops up the message anytime I drag one of these calculated fields into the visual. By the way, its with all kinds of visuals…
Thanks
Hi @Etai
Are you trying to do this calc in Dataset ? and the filed takeoff is Boolean value or a string type ?
If the filed is string type, you need to enclose the value TRUE in single or double quotes.
and for the second calculation try using CountIf funciton
The field is a string (true or false). Why should the second part be a countif?
The field (takeoff) has two strings - TRUE or FALSE. I want to know how much the percentage of true is out of the total…
Thanks 
@Etai - Thanks for posting your query. I just tried to replicate it at my end in a very simple manner. Please see the below snapshot depicting the scenario and steps. Hope this helps!
Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!
Thank you very much!
I will say that on a dummy dataset I created like you did it worked but in our DB it did not… something very weird. I t happened with another calculated field in another dataset so we will contact AWS for their support.
I appreciate your help
