Visualization options for minutes:seconds format

I'm working with the Average Time on Site (seconds) field from Adobe Analytics. It comes through our connector as a fixed decimal and I'm using SEC_TO_TIME(`Average Time Spent on Site (seconds)`) to format the data in minutes and seconds. This works fine in a table report, but I can't find any other chart type that would work with data formatted like this. Am I missing something ?

Answers

  • @cthtcc If you want do set up a card of a different chart type you could use the fixed decimal field as the value, and then use the formatted column as the data label using tooltips

  • Great idea. Thanks @MichelleH !