ShaneB Contributor

Thanks for the quick response!

Perfect. Thank you so much!

Domo Support was able to create a beastmode to do this. Example: To get the Average Abandoned Time take = (SUM(`abntime`)/SUM(`abncalls`))/60. To convert mintues and fractions of a minutes this beastmode was created concat(floor(IFNULL(((SUM(`abntime`)/NULLIF(SUM(`abncalls`),0))/60),0)),'.', -- 1.8 = time in min --…

Thanks for your continued assistance. My imputs are in the correct format, so I am good there. Now, when I use time_to_sec, the beastmode drops the decimal and gives me just a whole number (2.25 becomce 2 and 1.85 becomes 1). I have reached out to Domo Support for assistance.

It is not rounding to a whole number just to two decimal places. This is not an issue. My main concern is breaking down a minute and and fractions of minutes to minutes and seconds. Example: 2.25 minutes is 2 minutes and 15 seconds. I am stuck at converting the .25 into seconds and then adding it the 2 minutes, so my…

Thanks for the response Aaron. I have already tried sec_to_time. All get is the column changes to a text format and a value of 1.

So I created a new column in the ETL to divide the two columns to get my seconds, however the ETL is rounding up and dropping the decimal point. If I can find a solution to this, time_to_second function should work.

So this is what I tried sec_to_time(`abntime`/`abncalls`) and it was valid but returned nothing but 0.

Thanks ValiantSpur for the article. So I have a beastmode that calculates the seconds (column A devided by column B to get this number that I needed converted into hh:mm:ss. I tried to include that in the SEC_TO_TIME() function but it did not work. Any suggestions?

Thanks for the help!! I do not see an "accept as solution"

Does this beastmode remove weekend days?