help with expression

[Anonymous]

I need to calculate the status by day , if there is one failure per day .. the status is fail ,if all statuses are success then success ..

so basically i need a new column with one status either fail or success, below is my sample data i am aggregating the data by date and concatenating the status

[Anil_Babu_Samineni]

May be create one line in script

If(SubStringCount(DataStatus, 'failure','failure'), 'success')

[tresesco]

Try like:

If(SubStringCount(Concat(DataStatus), 'failure'),'failure', 'success')