I am having lots of trouble trying to figure this conversion out.. I have an excel file that I am bringing into domo.. within the card (table format) I am trying to get the average (as the average column already existing cannot be properly summed within domo). I am trying to take the 'talk time' divided by 'call id count' to get the 'average' which should match the 'average TALK TIME' but the new column 'avg talk time' is not working as expected..
the beast mode for the 'avg talk time' is :
ROUND(
(
(HOUR(TALK TIME
) * 3600) +
(MINUTE(TALK TIME
) * 60) +
SECOND(TALK TIME
)
) / CALL ID count
)
Anyone deal with this issue or know a solution?