Ifelse Calculated Field Partial Incorrect Syntax

Question & Answer
, , ,
1

I’m trying to generate a calculated field using two source columns. The first part of the field (up to DaysOpen) works, however it errors when I introduce the second part (up to tostring).

ifelse(Daystoclosure>=0 AND Daystoclosure<=15, “<15”, Daystoclosure>=16 AND Daystoclosure<=30, “<30”, Daystoclosure>=31 AND Daystoclosure<=45, “<45”, Daystoclosure>=46 AND Daystoclosure<=65, “<65”, Daystoclosure>=66, “>65”, DaysOpen>=0 AND DaysOpen<=15, “<15”, DaysOpen>=16 AND DaysOpen<=30, “<30”, DaysOpen>=31 AND DaysOpen<=45, “<45”, DaysOpen>=46 AND DaysOpen<=65, “<65”, DaysOpen>=66, “>65”, tostring({Days Investigation Open}))

Can anyone assist?

Thanks!

2

tostring needs to be toString

3

Hi @hopeah . Did Max’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!