Visualization options for minutes:seconds format

Options
cthtcc
cthtcc Member
in Charting
avg time on site data .png

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

  • MichelleH
    MichelleH Coach
    Options

    @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

  • cthtcc
    cthtcc Member
    Options

    Great idea. Thanks @MichelleH !

Categories