Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be create one line in script
If(SubStringCount(DataStatus, 'failure','failure'), 'success')
Try like:
If(SubStringCount(Concat(DataStatus), 'failure'),'failure', 'success')