Hi everyone,
I am trying to create a funnel portraying a sequence of events.
Each column currently has a value (date, int., string etc.)
I want to change some of the data to Boolean fields that represent success or failure. e.g. I have a start and end time of upload. If there is a start time but no end time it means to process failed. Thus, I want to change the null in the cell into “Failed”. Or, change an int. to a string value (3=complete, 4=fail, 1=processing etc.).
What formulas do I use?
Thanks!
Etai
Hi @Etai_Fiedelman
you cant replace values within a existing field but could create a new field.
something like
status =
ifelse(isnotnull(startdate) and isnull(enddate),"failed",enddate)
BR
1 Like
Thanks :),
I changed it to the following (according to the columns names in my table) - ifelse(isnotnull({created_at}) and isnull({upload_completed_at}),“failed”,{upload_completed_at})
But it does not seem to work. It said the syntax is wrong.
Do you have any idea why?
try to replase the “failed”,{upload_completed_at}) with “failed”,"ok"). I guess you cant use string and date in the same field.
Thank you very much, I appreciate it (new here :)). Unfortunately not working yet. This is what I get:
your syntax coloring looks wrong
should look like
ifelse(isNotNull({created_at}) AND isNull({upload_completed_at}),"failed","ok")
Thanks!!!
It worked perfect, I see the AND instead of and.
If I can ask another question is how to convert a certain value into text. Lets say I have an integer numbered 3. It represents “Completed”, or 4 which represents “failed”
I really appreciate your help
same logic.
ifelse(field=3,"completed",field=4,"failed","somethingelse")
Thank you very much for your help!
1 Like